AD 2007-04-19 R1
Registered aircraft · 108,434
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:2007-04-19-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:2007-04-19-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:2007-04-19-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:2007-04-19-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.
N41507Welty William Craig Trustee · Palm Springs, CAN41508Cobb Ralph B · Nicholasville, KYN41509Jw Rew Aviation LLC · Wilmington, DEN4150HThomas Brett · Gettysburg, PAN4150LBlankenship Daniel S · Paso Robles, CAN4150NMarland Robert T Jr · North Platte, NEN4150RLewis Aeronautical LLC · San Antonio, TXN4150SDirks Ricky B · Derby, KSN4150YFlying Bullfrog LLC · Virginia Beach, VAN4150ZDalks Leasing Inc · Wilmington, DEN41510Clemente Motor Inc · Wilmington, DEN41512Billingsley Randall F · North Platte, NEN41519Moloney Phillip M · Lexington, KYN4151FSmith Anna J Trustee · Newport, NYN4151HMoore Darren C Trustee · Torrance, CAN4151SMidland Avionics LLC · Louisville, KYN4151TState Of Alaska · Anchorage, AKN4151XT W LLC · Brazil, INN4151ZFischer Mackenzie A · Willow, AKN41520Heess Brandon L · Encinitas, CAN41522Senecal David R · Lawrenceville, GAN41523Able Kenneth Charles · Concord, NCN41529United States Department Of Agriculture · Cedar City, UTN4152AHarms Harvey Dennis · Chugiak, AKN4152HMountain West Aviation LLC · Denver, CON4152JPaulson Kim A · Devils Lake, NDN4152NAir LLC · Salem, ORN4152RRoby Richard J · Columbia, MDFirst renewal noticeN4152ZRappe Craig E · Wasilla, AKN41530Dahl Ranch Inc · Camp Crook, SDN41533Braden Aviation LLC · Easton, PAN41535Mjh Aviation Inc · Houston, TXN41537Lenko Mark A · Lovettsville, VAN41538Sunrise Aviation Inc · Ormond Beach, FLN41539Johnson Mark D · Debary, FLN4153AP B Odom Enterprises Inc · Oklahoma City, OKN4153CJet Care Corp · Roseville, CAN4153DBarker Bobby G · Gilbert, AZN4153GHeli Aviation Holding II LLC · Newark, DEN4153HBachman Aviation LLC · Independence, IAN4153MLincoln Roger Trustee · Gildford, MTN4153PHilty Robert · Wheatland, WYN4153SJones Thomas M · Garden City, KSN4153XWhite Gary C · Silverdale, WAN4153ZRocky Mountain Motor Service · Dupuyer, MTN41540Metro Aircraft Inc · Bloomington, MNN41542Brolan Aviation LLC · Kansas City, MON41547Markin Erik · Starkville, MSN41548Ravotti Air LLC · Leechburg, PAN41549Fisher Aviation LLC · Vacaville, CA
Back to AD 2007-04-19 R1