AD 81-18-04 R2
Registered aircraft · 81,733
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:81-18-04-R2')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2')
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:81-18-04-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2') 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.
N7317XMoore Samuel B · Tucson, AZN7317YComanche 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, TXN7319TAlberta Aviation LLC · Wyoming, MIN7319WDavis Jeffrey M · Phoenix, AZN7319XHays Software Development LLC · Timnath, CON731ACAtp Aircraft 9 LLC · Wilmington, DEN731AXAerodynamic LLC · Aurora, ORN731CKRobinson Michael F · Granbury, TXN731CLNby Productions · Manassas, VAFirst renewal noticeN731FLLibrino 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, CTN731SMSkyline Flight Services LLC · Millen, GAN731TBoard Of Trustees Of Southern Illinois University · Murphysboro, ILN731TATomlinson Aviation Inc · Ormond Beach, FLN731TDJohnson Thomas R · Lancaster, OHN731TXRegistration Pending · Harrah, OKRegistration pendingN731UACherry Hill Aviation Inc · Freetown, INN73200Burns Kurtis L · Clyde Park, MTN73209Goldberg 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 81-18-04 R2