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.
N7365GPray Aviation Inc · Augusta, KSN7365KKnutsen Wayne R · Tioga, NDN7365WRobert Jason T · Fernandina Beach, FLN7365YLoguidice Anthony · Bethlehem, PAN73660Hancock Brian · Edmond, OKN73662Flores Francisco H · Avondale, AZN7366DMh Aviation Inc · Lancaster, CAN7366FDesantos Rance · Baldwin, NYN7366LBoles Quincy · Panama City, FLN7366WBatchelder Norman · Newport Beach, CAFirst renewal noticeN7366YShockley Kenlon D · Aurora, CON73671Registered aircraftN7367FDuffys Aircraft Sales And Leasing Inc · Neillsville, WIN7367JWise Dustin A · Fairbanks, AKN7367KSpivey Harold E · Thomaston, GAN7367LRegistered aircraftN7367WRapp Stephen Martin Trustee · Zephyr, TXN73686Falcon Aviation Inc · Farmington Hills, MIN7368FW Tech Consulting Inc · Wilmington, DEN7368JDylan Branch LLC · Tomball, TXN7368KLahn James A · Bemidji, MNN7368LBohman John T · Monona, WIN7368WBurkholder Earl F · Middleburg, PAN7368YHoenmans John P · Roseville, CAN7369JSmith Zachary T · Nokesville, VAN7369KRidings Dustin Eugene · Oconto, WIN7369LMcdonnel Jack E Jr · Woodsboro, TXN736AAHoover Brian A · Warsaw, INN736DWGertiser Frank M · Lapeer, MIN736FHoffmanns Aircraft Services Inc · Loxahatchee, FLN736JBBrownell Kenneth C · Leverett, MAN736LBSkyraider Aero Club · Spokane, WAN736NDUnd Aerospace Foundation · Grand Forks, NDN736PAConnection Leasing Co · Dallas, TXN736RMBagwell Danny A · Arley, ALN736SRegistered aircraftRegistration pendingN736TRLangrell Sterling S · Woodburn, ORN7370Kittinger Russell P · Birchwood, WIN73702Shiles Darrel J · Baltimore, MDN73707Leading Edge Flight Academy LLC · Bend, ORN7370JBoone Bradford D · Lincoln, MEN7370KWhitney Aviation LLC · Watertown, SDN7370WDonahue Emily Stacy · Dallas, TXN73719Purdue Aviation LLC · West Lafayette, INN7371DLohse Teal K · Cordova, AKN7371KWagner Stanley M · Terra Ceia, FLN7371LMcewen Michael Trustee · Overgaard, AZN7371WVista I Inc · Smithville, OHN73726Wings Over Texas Holdings LLC · Denton, TXN73728Crowe Robert B · Del Valle, TX
Back to AD 90-04-06 R1