AD 90-04-06 R1
Registered aircraft · 68,377
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:90-04-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:90-04-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:90-04-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:90-04-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.
N73JFFreeburg John D · Fruitland, IDN73JGMeyer Gordon W · Huber Heights, OHN73JTRegistered aircraftN73KLTanych Tyler · Inverness, FLN73LMKrueger Carl R · Put In Bay, OHN73LNHelzer Jarrod · Antioch, CAN73MDReed Henry J · Jacksonville, NCN73MSJohnson Kevin N · Bethpage, NYN73PAJones Brandon B · Saint Francisville, LAN73PDToribio LLC · San Antonio, TXN73PFSinor Delbert · Ozark, MON73PPArew Aviation LLC · San Tan Valley, AZN73PWWarren John M · El Paso, TXN73RZBas Part Sales LLC · Greeley, CON73SSchulze Craig W · Burbank, CAN73SDMedlock-Turek Patick Evan · Clifton, NJN73SHEaton Michael J · Killen, ALN73STClearskys Aero LLC · Seneca, SCN73TDWeber Michael Scott · Gonzales, LAN73TSWeene Michael L · Moultonborough, NHN73VPyle Dana · Naples, FLN73VMSecurcloud LLC · Castleton, NYN73WGGlattli William H · Boynton Beach, FLN73WRStanton Fred H · Amherst, NYN73ZFlying Rocks LLC · Sparkill, NYFirst renewal noticeN7400DSmith Dwight S · Ann Arbor, MIN7400KLopez Lionel A · Wasilla, AKN7400RHambey Eric M · Walnut Grove, MON7400YWright Amos L Jr · Enterprise, ALN74024Milner Stephen L · Dallas, TXN74026Coburn William E · Carrollton, VAN74027Harvey James R · Ocala, FLN7402RReynolds Gary W · Forest, VAFirst renewal noticeN7402VKendrick Brian S · Kerrville, TXN7402YN5746u LLC · Dover, DEN7403JMejia Ramirez Martin E · Perth Amboy, NJN7403KAnderson Jeff · Lewisville, NCN7403PElliston Charles R · Brighton, CON7404KRegistration Pending · Eagle River, AKRegistration pendingN7404RT&G Aviation Services LLC · Temple, TXN7404YSlowpoke Air LLC · Palm Harbor, FLN74051Plane Fun LLC · Valdosta, GAN74052Macdonald Mark A · Muskego, WIN74057Madden Patrick · Fort Lauderdale, FLN74058Ricci Anthony Albert · Bishop, GAN7405GStan And Amy Weyer Aircraft LLC · Punta Gorda, FLN7405JMills Bailey J · Salem, ALN7405KPedersen Larry A · Waynesboro, PAN7405VBarrett Ronald A Jr · Shreveport, LAN7405WGo Fly Az LLC · Gilbert, AZ
Back to AD 90-04-06 R1