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.
N7117GBaker Brady B · South Hero, VTN7117KKlutsch Joseph R · King Salmon, AKN7117PRegistration Pending · Sandia, TXRegistration pendingN7117VNrv Flyers Inc · Blacksburg, VAN7117WMitchell Cameron A · Hopkinsville, KYN7118PSuarez Aaron M · La Habra Heights, CAN7118QMartin Stephen T · Green Cove Springs, FLN7119BDelaney Patrick J · Marion, TXN7119DBuell Travis · Harper, TXN7119MSutton Aircraft Salvage LLC · Palmer, AKN7119PLowry Wilson R · Leonardtown, MDN7119UTtwn Media Networks LLC · New York, NYN7119VMark Youngblood Pa · Naples, FLN7119YFlydunn.Com Inc · Jacksonville, FLN711ABL J S Enterprises Inc · Albany, TXN711APStrzelski Edward · Perkasie, PAN711AVAa Aero Inc · Fairfield, NJN711AZGriffith Grading Co Inc · Newnan, GAN711BCSummit Air One Inc · Wilmington, DEN711BDCoburn Eric E · Leesburg, INN711CAZuber Robert W · Culver, ORN711CHYoung Vernon P · Metter, GAN711CKStecker Tyler J · Spokane, WAN711CVSmtm Holdings Inc · Wilmington, DEN711CZRutan Aircraft Flying Experience · Brookshire, TXN711DFFly Mooney LLC · Phoenix, AZN711DLPalm Beach Flight Training Corp · Lantana, FLN711DQNtx Citabria LLC · Wichita Falls, TXN711DTMcclellion W Richard · Anderson, SCN711EEBrunson Douglas H · Burnet, TXN711EMBlue Sky Jet Services LLC · Lititz, PAN711EUSuperior Rents & Sales Inc · Springfield, MON711EWWard Lumber Company Inc · El Cajon, CAN711EZSparrow International LLC · Littleton, CON711FLFernandez Kevin · Fuquay Varina, NCN711GJohnson Harold V · Bayfield, CON711GTRadcliff Charles · Las Vegas, NVN711HYTegeler Walter S · Westminster, MDN711JGRv Guys LLC · Peachtree City, GAN711JJReady Aim Flyer LLC · New Castle, DEN711JSSterling Flight Training · Jacksonville, FLN711KFJ-Com Aviation LLC · Richland, MSN711KKRegistered aircraftN711KNLowe Kevin · Martinsville, INN711LPJohnson Tommy A · Grand Junction, CON711NDFlight Leasing Corp · Wilmington, DEN711NECommander Flight Group LLC · Charlotte, NCN711PKKramer Peter W · Copper Center, AKN711PTTaylor Stephen N · Punta Gorda, FLN711QSaddlemire Joshua S · Lake Arrowhead, CA
Back to AD 81-18-04 R2