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.
N73477Nationwide Aviation LLC · Hudson Oaks, TXN7347DOwens Tyle M · Kenai, AKN7347GN7347g LLC · Miami, FLN7347PVan Eyck Christopher · Cottonwood, CAN7347WHinzman Mark D · Reno, NVN73481N73481 LLC · Eaton, CON73486Begley Edward · Glasgow, KYN73487Spiess Michael Trustee · Montague, CAN73489Total Flight Aircraft Leasing LLC · Apex, NCN7348BPatry Andrew · El Mirage, AZN7348GHardy James H · Albany, NYN7348JDippolito Mario M · Sherwood, ARN7348LMcmahan Harley B · Gakona, AKN7348PSouthern Aircraft Consultancy Inc Trustee · Casper, WYN7348WRosenau Dillon L · Upham, NDN7348XShielded Holdings LLC - Series Av 11 · Katy, TXN7348ZPittsburgh Soaring Association · Pittsburgh, PAN7349814a Flying Club Inc · Mooresville, NCN7349BWilliams Kiplin S · Midland, NCN7349JWolfe Frank A · Nahcotta, WAN7349KWimberly Fred N · Callao, VAN7349PMathison John M · Vancouver, WAN7349WGritzo Russell E · Edgewood, NMN734AEFlight Club 502 Inc · Louisville, KYN734AHAnderson Zachary Q · Rudyard, MTN734AMGlobal Flight Training Solutions Inc · Immokalee, FLN734AQBarrans Daniel L · Glenmoore, PAN734ASStory Larry W · Double Oak, TXN734AULeading Edge Aviation Inc · Doylestown, PAN734AXPenel Aviation Corp · Baldwin, NYN734AYRico Aviation Services Inc · Miami, FLN734BBLeading Edge Flight Academy LLC · Bend, ORN734BFMortensen Jonathan J · Grovetown, GAN734BGVancina Simon J · New Lenox, ILN734BHMy Way Aviation LLC · Weston, FLN734BNAlameda Aero Club · Alameda, CAN734BQTri State Aviation Inc · Wahpeton, NDN734BTSorbi Aviation Inc · El Cajon, CAN734BUAirplanes And Attitude LLC · Mckinney, TXN734BVTurner Richard D · Panama City, FLN734BWSuperior Aviation Gateway LLC · Tampa, FLN734BXGreene Travis Charles · Acworth, GAN734BZBurleson Cameron Reynolds · Oak Island, NCN734CACobb Brian A · Destin, FLN734CCFranks Janice G · Eagleville, TNN734CFRivertown Flying Partnership · Marine On St Croix, MNN734CHC & R Aircraft Llp · Perry Hall, MDN734CJWings Over Texas Holdings LLC · Denton, TXN734CLStates Construction Company · Indianola, IAN734CP5280 Flying Club LLC · Castle Pines, CO
Back to AD 81-18-04 R2