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.
N924AZN924az LLC · Miami, FLN924CSobrado Victor M · Norman, OKN924CSBeinhauer Emerson R · Naperville, ILN924DLester Christopher J · Vancouver, WAN924DBFlying Veterans Club Of San Francisco Inc · Belmont, CAN924DMSmoketown Helicopters LLC · Smoketown, PAN924DWLive Free And Fly Hard LLC · Santa Cruz, CAN924EIzzard William S · Crescent City, FLN924JHSmith Nigel A · Winona, MNN924JLGross John L · Carthage, MSN924JPProck Jack A · Auburn, CAN924JWStephenson James M Jr · Hyampom, CAN924KAEvanoff Mark Alan · Saint Augustine, FLN924LMAviation Industries LLC · Aurora, ILN924LPEastern Cincinnati Aviation Inc · Batavia, OHN924MCJ Airco LLC · Nashville, TNN924NDUniversity Of North Dakota · Grand Forks, NDN924PLWilliamson Jay S · Phoenix, AZN924SAGiber Sharon G · New Port Richey, FLN924SHHillsboro Aero Academy LLC · Hillsboro, ORN924SJRickets And Associates LLC · Ardmore, OKN924TEPlyler Robert S · Spring, TXN92500Romeo Charlie Aviation LLC · Stuart, FLN92505Thunderbird Aviation Inc · Bloomington, MNN92508Pierce Stuart · Ridgefield, WAN9250CRegion Flyers LLC · Valparaiso, INN9250DJouflas Nikos A · Anchorage, AKN9250LBullitt Richard T · Humble, TXN9250VFlight Trainer LLC · Wilmington, DEN92511Mckay Donald A · Soldotna, AKN92515Bowen Bruce C · Sturgis, SDN9251EArrowpoint Investments LLC · Mountain Brk, ALN9251JGholami Amir K · Santa Rosa, CAN9251MFelix Eric · Oshkosh, WIN9251SAayan Air LLC · Westfield, MAN9251WHering Lloyd L · Boulder, CON92523Durner Charles L · Lewes, DEN92525Sale Reported · Palmetto, FLSale reportedN9252HStratus Aviation LLC DBA · Vacaville, CAN9252JFlying Wrenches LLC · Cairo, NEN9252MStarfox Aero LLC · Hays, KSN9253Gorman John J III · Statesville, NCN92536Ott Dean R · Carrollton, OHN92538Todd Terry A · Firth, IDN9253ABowman Gerald L · Santaquin, UTN9253DHand Keith A · Anchorage, AKN9253LMaj Holdings LLC · Norfolk, VAN9253MBlue Eagle Air LLC · Singer Island, FLN9253RDr Equipment LLC · Ackerly, TXN9253SKnuth Charles Allen · Avon, IN
Back to AD 81-18-04 R2