AD 87-10-06 R1
Registered aircraft · 72,010
Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.
Query with SQL
duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:87-10-06-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-10-06-R1')
ORDER BY n_number"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:87-10-06-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-10-06-R1') ORDER BY n_number
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
N6247JInternational Air Services Inc Trustee · Carson City, NVN6247LChandler Air Service Inc · Chandler, AZN6247USchaefer John A · Liberty Hill, TXN62486486 Aviation LLC · Worthington, OHN62488Leaf Air LLC · Queensbury, NYN6248CFort Leavenworth Flying Club · Fort Leavenworth, KSN6248DEscobar Frank · Tampa, FLN6248MRoss Michael M Trustee · Anchorage, AKN6248RHewitt Chad R · Vernonia, ORN62491Registration Pending · Strawn, TXRegistration pendingN62494Pacific Fleet Aviation LLC · Rochester, NYN62495Gentrys Flying Service LLC · Prattville, ALN62498Hogan Michael J · Bonita Springs, FLN6249JAkwari Aerospace LLC · Burbank, CAN6249PKeller Richard A · Stacy, MNN6249VN6249v LLC · Park Ridge, ILN6249WWall Scott R · Franksville, WIN6249YPapagni Demetrio G · Madera, CAN624ACAnunson Andrew M · Pound, VAN624APThomas Lucas G · Beebe, ARN624AQHigh Flight Academy LLC · Allison Park, PAN624BBPetey LLC · Lake Arrowhead, CAN624BTJespersen Barry W · Olympia, WAN624CECertified Equipment Inspections LLC · Washington, PAN624CJJones Steven Clark · Flagler Beach, FLN624CWSkypeck John · Nevada City, CAN624DGRv4 Adventures Inc · Wilmington, DEN624DPHamons Spencer · Cookson, OKN624FTFlorida Institute Of Technology · Melbourne, FLN624GTTrue Lumen Aviation LLC · Grosse Pt Shr, MIN624HNeed For Speed Inc · Dover, DEN624JTStandhart Gary · Wickenburg, AZN624LLLevin Larry R · Lincoln, RIN624MCStauffer Mark A · Appleton, WIN624MEPetry Christopher M · Frankfort, ILFirst renewal noticeN624MSMcclure George E Jr · Nipomo, CAN624NDZaki Amir S · Orangevale, CAN624RCJeffrey Guy · Centerburg, OHN624SStoro Eddy · Netarts, ORN624SEPrysi Mary H · Dundee, OHN624SXDeeds Andy · Larkspur, CON624TCArnaoutis Antonios D · Ormond Beach, FLN624TFDominy Kenneth W · Ave Maria, FLFirst renewal noticeN62502Hill Andrew T · Smithville, TXN62503Back Forty Flying Club Inc · Roanoke, INN62508Pacific Fleet Aviation LLC · Rochester, NYN6250CShields Ray Winfrey III · Marietta, GAN6250UAsb Jones Aviation · Uniontown, OHN6250WCummings Property Restoration LLC · Bullard, TXN62511Dezee Matthew J · Corinth, KY
Back to AD 87-10-06 R1