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.
N6539RSpencer Alexander Joshua · North Las Vegas, NVN6539WYounglove Donald L · Mendota, ILN653BQQuilty Stephen M · Abingdon, VAN653CHKelley Aviation Consultants LLC · S Williamsport, PAN653DFRv 10 LLC · Kalispell, MTN653FTFlorida Institute Of Technology Inc · Melbourne, FLN653JFRegistration Pending · Elizabeth, NJRegistration pendingN653KBSkyhawk Aviation Inc · Marietta, GAN653PSCorcoran Matthew L · Redondo Beach, CAN653QPhillips Robert B · Coshocton, OHN653RVRoberts Todd L · Friday Harbor, WAN653SHGivens Tyler · La Vernia, TXN653SMMckinney Steven R · Hamersville, OHN653SRVertex Aviation Services LLC · Burlington, WAN653WChesebro Ben D · Oro Valley, AZN653WWBerry Aviation Inc · San Marcos, TXN654Roderick Paul E · Talkeetna, AKN6540PStauffer Charles R · Pittsburg, MOFirst renewal noticeN6540WRiggs Charles A · Pembroke Pines, FLN65413John Mccaskill Enterprises LLC · Tifton, GAN6541URegistered aircraftN6542HOwens Flight Training LLC · Lafayette, LAN6542PSmith Noland F Jr · Chattanooga, TNN6542VHarris Dakota · Goose Creek, SCN6542WBaird Philip D · Judith Gap, MTN6542ZKingsley Kiman J · Miller, MON65431Caliber Capital Holdings LLC · Homosassa, FLN6543DBatte Randall E · Forest, MSN6543UGiesey William · Philadelphia, PAN6543VChupito Sabrocito LLC · Paso Robles, CAN6543WJts Aircraft LLC · Rock Hill, SCN65445International Air Services Inc Trustee · Carson City, NVN6544AMatthews Aviation LLC · Hardinsburg, KYN6544KWaldron Ronald J · Strongsville, OHN6544TCourtney John T · Woodbridge, CTN65452Jf Aviation LLC · Minot, NDN65459Vitatoe Industries Inc · Chillicothe, OHN6545DCosta Flying Service Inc · Painted Post, NYN6545GBoomer Aviation Inc · Fort Walton Beach, FLN6545HAmerican Patrols Inc · Midland, TXN6545RBonilla-Cruz Carlos · Houston, TXN6546FMiljour Jack A · Sanborn, NYN6546UBadlands Flyers Inc · Watford City, NDN65472Registered aircraftN65474Tk Leasing Lc · Fruit Heights, UTFirst renewal noticeN6547JMeyer Mark A · Vass, NCN6547SMiller Bradley J · Joliet, MTN6547WMacclements Jonathan E · Austin, TXN65489Flight Solutions LLC · Columbia, MON6548ESewell William G Jr · Bremen, GA
Back to AD 87-10-06 R1