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.
N7266NBeck Robert A · Cove, ORN7266PGrover Donald G · Canby, ORN7266QLima-001 LLC · Muscatine, IAN7266WNewland Hunter R · West Valley City, UTN7266YAvero Aviation LLC · Dover, DEN7266ZBearing Tree Land Surveying LLC · Oklahoma City, OKN72671Vfr Aircraft And Training LLC · Jackson, MON72675Chapel Hill Flying Club Inc DBA · Sanford, NCN7267FRegistered aircraftN7267GWells Jack D · Newtown, MON7267JSe Aviation LLC · Boise, IDN7267TDmcc LLC · Lewes, DEN7267WGillespie Michael Lee · Jacksonville, FLN7267YVolatilis Aviation LLC · Collinsville, ILN7267ZHoffpauir Jeremy · Broussard, LAN72681Riggs Benjamin D · Reynoldsburg, OHN72689Brown Nathan · Snellville, GAN7268DLarsen Daniel R · Kenai, AKN7268FFarber Gerald · Las Cruces, NMN7268GSteel & Supply Co LLC · Pensacola, FLN7268KFelts Field Flying Club · Spokane Valley, WAN7268LFletchair Inc · Comfort, TXN7268PSurdex Corp · Chesterfield, MON72692Mccurdy Dwight B · Anderson, INN7269416 Sandals LLC · Tuscaloosa, ALN72697Cbt Aviation LLC · Bellingham, WAN7269BReece Vance · Winnsboro, TXN7269FChandler Joseph · Amana, IAN7269GBranson Barry R · Shasta Lake, CAN7269PBoucher Bobbi · Fredericksburg, VAN7269QBaker Mark · White Bear Lake, MNN7269RSm1019 LLC · Gillette, WYN7269WButtercup Express LLC · Woodward, OKN726ACGrass Roots Aviation LLC · Bend, ORN726AJStarr Alan D · Senoia, GAN726AMRegistered aircraftN726BBStater Christopher B · Charlotte, NCN726CMEvans Douglas A · Amarillo, TXN726CPCivil Air Patrol · Maxwell Afb, ALN726DFTactical Aviation LLC · Brownstown, MIN726DTThompson Donald H · Tallahassee, FLN726EREmbry-Riddle Aeronautical University Inc · Prescott, AZN726GHead David A Trustee · Livermore, CAN726GASouth Texas Air Force LLC · Mission, TXN726JHClearview Flying Club Inc · Westminster, MDN726JVGill James J · Anchorage, AKN726LLRegistration Pending · Fargo, NDRegistration pendingN726LUTextron Aviation Inc · Wichita, KSN726MBBurgos Orlando · Venice, FLN726MMRiverside Flight Academy LLC · Riverside, CA
Back to AD 81-18-04 R2