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.
N60FDBarnstorm Aero Inc · Sacramento, CAN60GAGlidewell Aviation Inc · Parkland, FLN60GLMiko Pawel Marcin · Santee, CAN60GZAbl Aviation Inc Trustee · Wilmington, DEN60HEagle Flight Squadron Inc · East Orange, NJN60HASteeneck Robert T · Washougal, WAN60HCKing Winn K · Gladewater, TXN60HFTexas Flying Club Inc · Bryan, TXN60HUOne Pft LLC · Denton, MTN60HYAnderson James D · Russell, KSN60JBHarmon Eagle LLC · Albuquerque, NMN60JKHiner Kirk J · Kenyon, MNN60KDBegeman Daniel L · Littleton, CON60KRRhea Keith H · Peck, KSN60LFNorthwoods Air LLC · Orono, MEN60LGEgmond Aircraft LLC · Lewes, DEN60LMNb Airplane Inc · Ithaca, NYN60LRBlake W Preston · Gainesville, FLN60LYLeon Roberts Enterprises LLC · Vienna, VAN60MRHansen Charles R · Covington, TNN60NAHampden Aviation Services Inc · Northampton, MAN60NCBalsley Matthew · Rowlett, TXN60PLPapa Lima LLC · York, NEN60PRHarben Grover III · Gainesville, GAN60RGodette James R · Scottsville, NYN60RBShrode Rafe C · Jewett, TXN60RTPaap Patrick · Menifee, CAN60SGRichard Amster · Brookline, MAN60SSDhone Shridhar · Livermore, CAN60SXDitzler Enterprises Inc · Grinnell, IAN60TBMoffet Brian · Santa Cruz, CAN60UKSouthern Aircraft Consultancy Inc Trustee · Casper, WYN60UMWbyaa LLC · Saline, MIN60UPBrietigam Charles T · Meridian, IDN60VWNix William C · Sterling, CON60WEVeillon Joseph B · Alexandria, LAN60WFEngels John · Edmond, OKN60WMSmith Ted J · Lakeland, FLN60WRAmbush One LLC · Memphis, TNN60WUWsu Campus Of Applied Sciences And Technology · Wichita, KSN60WWMorton Ronald S · Seguin, TXN60WYCannon Land LLC · Kalispell, MTN60YGLindstrom Dave C · Marinette, WIN60ZYBrewer Terry P · Oakland, IAN6100DSzostak Edward M · San Diego, CAN6100JFranklin County Flying Club Inc · Turners Falls, MAN6100PSuarez-Alicea Jorge A · Enterprise, ALN61011Inter American University Of Puerto Rico · Bayamon, PRN6101DHanson John A · Molena, GAN6101M316 Aviation LLC · Sandy, OR
Back to AD 81-18-04 R2