AD 72-03-03 R3
Registered aircraft · 17,028
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:72-03-03-R3')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:72-03-03-R3')
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:72-03-03-R3') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:72-03-03-R3') 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.
N92597Morgan Ent LLC · Richland, IAN925JKLonghorn Listings Inc · San Antonio, TXN925RRHahn John K · Evansville, INN92600Windh Steven R · Reedley, CAN9260GPeyton Julia H · Santa Barbara, CAFirst renewal noticeN9260XColvin Buster · Big Cabin, OKN92616Holby W Barrett Jr · Warren, RIN92638Van Raden Chris · Portland, ORN92639Pryor Aviation LLC · Hutchinson, KSN9263GN9263g LLC · Marshall, MON9263XMieloszyk Nicholas A · Elko, NVN92644Atkins Doug · Murfreesboro, TNN92648Bender Phillip H · Bloomingdale, OHN9265XWestern Pilot Service Inc · Phoenix, AZN92665Rupke Curtis · Washington, NCN9266GCole Mark A · Forest City, NCN9266XWeichert Robert S · Parker, CON9266ZR M B G Inc · Winnsboro, LAN92675Miller Saima A · Kodiak, AKN92677Burriss James E · Piedmont, SCN9267GWaypoint Financial Services LLC · Raiford, FLN92680E & T Research And Development LLC · Sanford, NCN92690Nelson Richard B · San Mateo, FLN92691Registration Pending · Lebanon, TNRegistration pendingN926MNPtw Consulting LLC · Atlanta, GAN92707Farquharson John L · Goldsby, OKN9270GFrye Warren S · Galax, VAN9270XCastle Rock Services LLC · Helena, MTN92712Pfister Michael J · Roanoke, ILN92725Tucker Kyler T · Cypress, TXN92726Gray Stanley Paul Jr · Temecula, CAN9272GSena James H · Edmond, OKN92739Mcmillin Michael C · Des Moines, IAN9273GPlisko Aviation LLC · Beaufort, NCN92746Hansen Barbara · Armstrong, IAN9274XGawlik Leslie W · Reisterstown, MDN9274ZIsham Shane A · Wichita, KSN92750Rauton Ken · Temecula, CAN92757Omegna Suzanne M · Spanaway, WAN92758Wayne Alan A · Flowery Branch, GAN92764Bernstein Jeffrey J · Swanton, MDN92776Rivera Rivera Jose Manuel Trustee · Royal Palm Beach, FLN92787Quade James C · Duluth, MNN92788Bas Part Sales LLC · Greeley, CON9279XKhoury Alain W · Wills Point, TXN927NBlue Sky Business Services Inc · Gardiner, NYN9280MRiley Dean A · Friday Harbor, WAN92814Kimbrell Tod L Jr · Itasca, TXN92815Halver Todd L Trustee · Advance, NCN92816Van Cleve G Steven · Windermere, FL
Back to AD 72-03-03 R3