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.
N74302Airpower Enterprises Ltd · Tampa, FLN7430PSchlosser Nelson L · Tucson, AZN7430RGomez Rodolfo · Sierra Vista, AZN7430VViaspot Inc · Sheridan, WYN7430WI Was Inverted LLC · Fort Myers, FLN7430YLavion LLC DBA · Zeeland, MIN7430ZMayes Brett R · Williams, CAN74319Koch Christopher G · Coloma, MIN7431DWilcox Darrol A · Nenana, AKN7431JHemmings Jack · North Vernon, INN7431VErnst Albert S III · Buda, TXN7431WKonkoi Roger E · Lumberton, NCN7431YRegistration Pending · Lynchburg, VARegistration pendingN74323Clark Daniel M · San Pedro, CAN7432DBlack Delwyn Joe · Irving, TXN7432GNichols Roy D · Cadillac, MIN7432JSingcharoen Kitikorn T · Riverside, CAN7432RHeil Dan M · Hooker, OKN7432VSpires William B · Minden, NVN7432WSheppardfox LLC · Germantown, TNN7433DPierce Stephan L · Graham, TXN7433GStyles Brian P · Cullman, ALN7433JYawn Charles L Jr · Denham Springs, LAN7433KMills Randall J · Monroe, MIN7433RValiair Lc Trustee · Casper, WYN7433ZDas Air Inc · Wilmington, DEN7434Armstrong Charles R · Annapolis, MDN74343Hindes Philip DBA · Charlotte, TXN74347Spitzer Helicopter LLC · Woodland Hills, CAN74349Prieve Barton G · Aurora, CON7434RMyers Lisa · Sandpoint, IDN7434WCarolina Clouds LLC · Dover, DEN74350Truong Philippe M · Fayetteville, ARN74353Hofer Gary D Trustee · Huran, SDN74356Windsor Robert M · Norman, OKN74359Ohlsson Patricia · Port Orange, FLN7435KHickey Aero Services LLC · White Hills, AZN7435VFreebird Ventures Inc · Oak Lawn, ILN7435WStanley Thomas Russell · Brighton, CON7435YStc Aviation LLC · Wilmington, DEN7435ZShortridge Randall R · Mesa, AZN74367T-Time LLC · Wasilla, AKN7436CMatanane Roke C · Barrigada, GUN7436GChickadee Aviation LLC · Rangeley, MEN7437Fedorka Paul R Trustee · Soldotna, AKN74370Ronald A Peterson Inc DBA · Orlando, FLN74374Speedbird Ventures LLC · Driftwood, TXN7437DM And E Ventures LLC · Pingree Grove, ILN7437JSchuch Rick J · Gays Mills, WIN7437PJohnson Stephen A · Huffman, TX
Back to AD 81-18-04 R2