AD 74-18-13
Registered aircraft · 1,642
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:74-18-13')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:74-18-13')
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:74-18-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:74-18-13') 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.
N90DDBas Part Sales LLC · Greeley, CON9107KBeidoun Bassam A · Auburn Hills, MIN911SAIntensive Medical Inc · Clermont, FLN913CBecker Claus · West Palm Beach, FLN914MGHolman Larry E · Cleveland, GAN9220CDixon Aviation LLC · Oakland, MDN9269CMcmillin George T · Bradenton, FLN926BBBb Air · Stuart, FLN927DMGoat Rancho LLC · Euless, TXN9297C831 Aviation LLC · Salinas, CAN934PHRossell Holdings LLC · Astoria, ORN936BWTriple J Aviation LLC · Mcconnelsville, OHN93PNHawkins Steven L · Grand Prairie, TXN9442CElevate Aviation LLC · Rathdrum, IDN945JKSweetair Aviation · West Monroe, LAN9494CChristensen Robert R · Mattawa, WAN94PLucas Matthew A · Mission Viejo, CAN951GTK And M Aviation LLC · Palm Harbor, FLN9561KRouth Kipp D · New Richland, MNN9599CDomenico Joseph A · Saint Germain, WIN95RAKennedy Crosswind LLC · Wellsburg, IAN9614CBravo Foxtrot Zulu Holdings LLC · Unionville, CTN9615CD Wayne Hollar Jr Dds Pa · Lenoir, NCN9657CFrantz Jeffery T Jr · Frankfort, ILN9675CRegistered aircraftN9695CTrhb Enterprises LLC · Danville, PAN96JBSigman Bruce A · East Brunswick, NJN96MLM & M Aero LLC · Wilmington, DEN97219Deull Jonathan S · Cornwall, NYN9725CPowell Mark · Grandville, MIN9729CEffingham Eta LLC · Effingham, ILN973SFInternational Air Services Inc Trustee · Carson City, NVN9768CHansen Kurt C · Washington, UTN9794CTaylor Aero Flights Inc · Wilmington, DEN9795CFernett Willard Shane · Peyton, CON97HRRoberts Harold S DBA · Spartanburg, SCN9884KSalt Air Inc · Wilmington, DEN989ASSkupin Charles G · Riverview, MIN98CTRote William E · San Marcos, CAN998MMHardcastle Eric · Holly Springs, NCN99ESGorsuch Larry · Richland, WAN99MGChaffee Michael D · Big Rapids, MI
Back to AD 74-18-13