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.
N7006QToney Edward L · Hampton, GAN7007Command Aero LLC · Newark, DEN70075Kennel Isaac John · Salt Lake City, UTN7007JKeltner Kody M · Meadville, PAN7007PAden Charles L · Hudson, CON7007TAnderson Karen Lynn · Wasilla, AKN7007WBiros Timothy D · Nya, MNN7007XConcho Aviation LLC · Sterling City, TXN7008AMitchell Shawn J · Red Bluff, CAN7008BMayes Russell F · Farmersville, ILN7008FSouthbound Aviation LLC · Jackson, TNN7008NRobinson Helicopter Company Inc · Torrance, CAN7008RPerchall Theodore G II · Fort Myers, FLN7008YHeather Jordan Flying Services LLC · Port Saint Lucie, FLN70095Eastern Kentucky University · Richmond, KYN7009DRegistration Pending · Waupaca, WIRegistration pending, pending cancellationN7009QJoiner Legacy Enterprises LLC · Joliet, MTN7009RJackson Donald W · Carthage, MSN7009WFarrell Thurston Construction LLC · Las Cruces, NMN700ABSale Reported · Lewes, DESale reported, pending cancellationN700AC4sons LLC · Mayfield, KYN700AGMash Kity J LLC · Grand Rapids, MIN700AKCampbell Mark D · Ashford, ALN700AWTailwheel LLC · Logan, UTN700BVN700bv LLC · Zeeland, MIN700BZBliss Robert Z · New York, NYN700CMoss Donald · Pinecrest, FLN700CNHoleshot Aviation LLC · Lodi, CAN700CROneglia Francis G · Hawthorne, FLN700DLArthur Aaron · Gold River, CAN700DRRadwanski D · Westmont, ILN700ECInglis Scott D · Incline Village, NVN700EEMatteo Properties Inc · Wickliffe, OHN700FMWahl Mark E · Oswego, NYN700GCRicks Auto Clinic Inc · Raytown, MON700GLPitcock Aviation LLC · Tompkinsville, KYN700GPHenderson Donald P · Lagrange, GAN700HHHubbell Jonathan E · Mccordsville, INN700HWHotel Whiskey LLC · Sylvania, OHN700JLHubbell Jonathan E · Mccordsville, INN700KFTurbine Motor Conversions LLC · Orange, CAN700KRStrange Jim · Tyler, TXN700LDNorthridge Consulting Enterprises LLC · Santa Clarita, CAN700MFEtavan LLC · Satellite Beach, FLN700MWSome Beech LLC · Bolivar, MON700PJShort Stephen A · Lake Placid, NYN700PMRar LLC · Louisville, KYN700RLGonzalez Richard J · Granbury, TXN700RVIngram Ronald W · Springfield, ILN700SDTms Aviation LLC · Bon Aqua, TN
Back to AD 87-10-06 R1