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.
N9DEAdams Beverly B · Garner, NCN9DFHorning Jason R · Thonotosassa, FLN9DLVeatch Gary W · Portland, ORN9DYHrutkay Charles S · Scenery Hill, PAN9EARyan Peyton G · Memphis, TNN9ECWagner Roger P · Jasper, TXN9ERCrist Skip · Manhattan, KSN9ETTorbett Edwin J · Athens, TXN9EVEdester Martin W · Berea, KYN9EYUnternaehrer Rolf G · Petaluma, CAN9FALandon Easton · Quartz Hill, CAN9FCEldridge Erin A · Seabrook, TXN9FNMyf Holdings LLC · San Diego, CAN9FPCendejas Agustin · Chino, CAN9FRDonaldson Thomas M · Granbury, TXN9FVGeorgia Forestry Commission · Macon, GAN9GDSchildberg Gregory M · Casey, IAN9GLCampbell Joseph P · Vail, AZN9GNGudgel Scott A · Ogallala, NEN9GXGrindahl Mervin L · Waseca, MNN9HJThornton Kendall R · Sonoma, CAN9HKEpperly Scott C · Montague, CAN9HZGrace River Ranch LLC · Saint Joseph, MON9JGHaynes Brian W · Shingletown, CAN9JJPlane Fun Inc Tr Trustee · Snellville, GAN9JSAuburn Flight Time LLC · Auburn, ALN9JTEverything Pitts LLC · Queen Creek, AZN9JUVaneau Philip · Wasilla, AKN9JWDrozd Thomas · Lake Dallas, TXN9KAEssex Aviation · Indianapolis, INN9KDGerada Matthew T · Bossier City, LAN9KKWessel Marvin E Jr · Camp Verde, AZN9KPEmmons Russell S · Waterbury, CTN9KRDavis Joshua A · Warner Robins, GAN9KTJacelon Charles E · Little River, SCN9KULafever George Alan · Tucson, AZN9KVHart Daniel K · Cullman, ALN9KZGlasgow James G · Stamping Ground, KYN9LEdwards Allan E · Oakland, CAN9LLRegistered aircraftN9LUNoel Michael P · Poplar Grove, ILN9MEArtmann James · Zimmerman, MNN9MGRossmann William L · Hillsborough, NJN9MLBobcheeto LLC · Newark, DEN9MRWelsh Keith L · Marshall, ILN9MYBermudez Tacito Octavio · Conyers, GAN9MZPeterson Wayne W · Burlington, WIN9NADmj Air LLC · Souris, NDN9NTHigh Times Adventure Co LLC · Columbiana, ALN9NYDanner Jason · Burleson, TX
Back to AD 81-18-04 R2