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.
N73170Jahawk Leasing LLC · Sugar Grove, ILN73171Jettmar Rainer U · Washington, DCN73172American Patrols Inc · Midland, TXN73174Welch Cleatus E · Orlando, FLN7317FMiller Steven G · Kent, WAN7317GSettles Lauren E · Owensboro, KYN7317JBengtson Timothy R · Boulder Creek, CAN7317YComanche Air Services LLC · Westminster, CON73181Nurse Alex S · San Diego, CAN73183Sandwich Aviation Inc · Somonauk, ILN73189Ellie Air LLC · Mabank, TXN7318DAir & Field Equipment LLC · Moore, IDN7318FTwo Weeks LLC · East Palo Alto, CAN7318GMay Curtis · Joplin, MTN7318JHdr Aero LLC · Lewes, DEN7318YBas Part Sales LLC · Greeley, CON73190Flying J Enterprises LLC · San Antonio, TXN73192Nationwide Aviation LLC · Hudson Oaks, TXN73195Saratoga Flyers Inc · South Glens Falls, NYN73197Seward Kent · Parma, IDN73198Davis Jimmy R Jr · Wharton, TXN73199Performance Polymer Technologies LLC · Roscommon, MIN7319DN7319d LLC · Port Saint Lucie, FLN7319FJdnichols LLC · Wichita, KSN7319GPiguzov Yevgeniy · Hillsborough, NJN7319JGross Randolph A · Round Rock, TXN7319WDavis Jeffrey M · Phoenix, AZN731ACAtp Aircraft 9 LLC · Wilmington, DEN731CKRobinson Michael F · Granbury, TXN731FLLibrino Filippo · Tomball, TXN731JCCrowder John T · Summerfield, FLN731JDReifschneider Harry III · Mesa, AZN731JSNapier James C · San Diego, CAN731MANance Gerald D · Bladenboro, NCN731NDAir Shares LLC · Casper, WYN731PKC & M Properties LLC · Chesterton, INN731RHBallenger Kenneth L · Tucson, AZN731RTWarndahl John · Kyle, TXN731SBSchuler Edward A Jr · Hamden, CTN731TATomlinson Aviation Inc · Ormond Beach, FLN731TDJohnson Thomas R · Lancaster, OHN731TXRegistration Pending · Harrah, OKRegistration pendingN73200Burns Kurtis L · Clyde Park, MTN73207Hendrickson Flying Service Inc · Rochelle, ILN73209Goldberg Peter S · Eagle River, AKN7320FRick Aviation Inc · Newport News, VAN7320JNextgen Flight Academy Inc · Riverside, CAN7320WSuchting Carl Joseph · Little Egg Harbor, NJN7320YSpruce John P · Liberty Hill, TXN73213Haig Gene · Palatine, IL
Back to AD 90-04-06 R1