AD 84-10-01 R1
Registered aircraft · 20,481
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:84-10-01-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:84-10-01-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:84-10-01-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:84-10-01-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.
N8481ZMoreau Lloyd J · Penrose, CON8482MBuck Carl R · Highland Village, TXFirst renewal noticeN8482QGregg Flying Service Inc · Durango, CON8482STwin Cities Aviation Inc · Blaine, MNN8482TOliver Chad · Groton, SDN8483SHolman David · Philip, SDN8483TSiegel Andrew J · Roy, UTN8483ZZietz Bode W · Eastland, TXN8484ZHendrickson Todd · Woodstock, ILN8485MFriday Harbor Wings LLC · Friday Harbor, WAN8486MSatsang Air LLC · Monterey, CAN8486SCalton Thomas C · Rutherfordton, NCN8487SYoder Dwight D · Bear, DEFirst renewal noticeN8487ZBingham Neal Lee · Taylor, TXN8488MMedia Stew LLC · Carson City, NVN8488ZGlacier Flight LLC · Kalispell, MTN8489MOconnell Timothy Ryan · Davenport, WAN8489SReading Michael P · Monee, ILN8489TGordon Robert A · North Pole, AKN8489ZDyer Joe E · Navasota, TXN848CPCivil Air Patrol · Maxwell Afb, ALN8490SHerring James N Jr · Nederland, CON8491QDry Bay Holdings LLC · Yakutat, AKN8491SOgrin Kirk V · Bigfork, MTN8491ZBoice Christopher T · Roseburg, ORN8492SFlight Testers LLC · Seattle, WAN8493MValiair Lc Trustee · Casper, WYN8494MCardinal Sg LLC · Mukilteo, WAN8495MCourtney Aviation LLC · Columbia, CAN8495TCullom Mitchell T · Anchorage, AKN8496QWord Forrest R Trustee · New Braunfels, TXN8496SOkon Randy W · Missoula, MTN8496ZRegistered aircraftN8499MCornale Michael J · Dwight, ILN8499SGraznak Timothy C · Greeley, CON8499TLewis Lawrence R · Newport, WAN849CPCivil Air Patrol · Maxwell Afb, ALN84DMGafni Tal · Scottsdale, AZN84EDAms Aviation LLC · Brashear, TXN84FFKoorenny Brian G · Clarkston, WAN84LMSchaefer Bernard C · Fairfield, TXN84LSBrenberger Mark L · Raleigh, NCN84MCOn-Site Mech LLC · Helena, MTN84SJLabelle Gregory D Trustee · Newbury Park, CAN84USMcginty Flying Service LLC · Jones, LAN8500TWhite Taylor D · Gainesville, GAN8501SWitschger Scott L · Albuquerque, NMN8503SCub Club Inc · Toddville, IAN8503TKolb Bryan C · Hutto, TXN8505SAir Repair Inc · Cleveland, MS
Back to AD 84-10-01 R1