AD 90-04-06 R1
Registered aircraft · 68,377
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:90-04-06-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:90-04-06-R1')
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:90-04-06-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:90-04-06-R1') 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.
N405MHCall One Inc · Clarinda, IAN405NDSmith Michael Christopher · Concord, NCN405RVNorberg Robert J · Las Vegas, NVN405SGriffing Flying Service Inc · Port Clinton, OHN405SBSky Bright Inc · Gilford, NHN405SPEastern Cincinnati Aviation Inc · Batavia, OHN405THNewgren Steven A · Kasilof, AKN405TSRichard N Appling · Ellensburg, WAN4060FJones Brent M · Las Vegas, NVN4060MStall Aero LLC · Burnsville, MNN4060XTroyer Randy · Goshen, INN40614Marcotte Stuart E · Soldotna, AKN4061MKrupinski Floyd M · Chugiak, AKN4061NChristensen Kier · Scottsdale, AZN4061XCorriveaw Florian J · Whitefield, NHN4061ZJones Michael D · Eagle River, AKN4062EReimler Dan T · Rozet, WYN4062PLgop LLC · Maple Grove, MNN40632Southern Aircraft Consultancy Inc Trustee · Casper, WYN4063GHorizon Flights Corp · Henderson, NVNon-citizen corporation, flight hours not reportedN4063XMellon Matthew J · Boone, NCN4063ZDenton Bobby L · Las Animas, COFirst renewal noticeN4064GLanyi Clifford M · Attleboro, MAN4064PVali Air Service LLC · Livingston, MTN4064QPasseno Mark A · Cheboygan, MIN4064XMtsh Aviation LLC · Wichita Falls, TXN4065529 Uniform LLC · Nashville, TNN40658Goodnight James J · Kannapolis, NCN4065EKubat Wayne DBA · Wasilla, AKN40663Moss Frank V · Punta Gorda, FLN4066BKuipers Abram B · Derby, KSN4066ENelson Flyers Inc · Louise, TXN40670Cavorite Aviation LLC · Lehi, UTN40679Skipper Consulting LLC · Athens, ALN4067PAircraft Guaranty Corp Trustee · Oklahoma City, OKN4067ZBenninger Timothy A · Cobleskill, NYN4068NThomas Averett V · Greensboro, NCN4068XCaldwell Timothy · Spencer, WVN40697Freiberg Industries Inc · State Center, IAN4069NGrady Kevin M · Spokane, WAN4069XRegistered aircraftN4069ZS&P Aviation LLC · Albuquerque, NMN406AArcher Aircraft LLC · Wilmington, DEN406ACLequire Paul D · Kingston, TNN406AFN406af LLC · Fort Pierce, FLN406AKPratt Benjamin C · Galena, AKN406DRKent Keith M · Ellijay, GAN406DSDelaware State University · Dover, DEN406FAStratus Rr LLC · New Castle, DEN406JASpartan Education LLC · Tulsa, OK
Back to AD 90-04-06 R1