AD 85-02-05 R1
Registered aircraft · 8,921
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:85-02-05-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:85-02-05-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:85-02-05-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:85-02-05-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.
N3225BLeguia Augusto A · Kathleen, GAN3227PTucker Patricia A · Hamilton, MTN3228BScites Robert · Toney, ALN3228PPopejoy Marc · Fort Scott, KSN3229PRiggs Charles A · Pembroke Pines, FLN322JK & M Aviation LLC · West Liberty, KYN322SMShivers James C II · Columbus, OHN3230BYoder Ranches Llp · Karval, CON3231ZWestern Skyways Inc · Montrose, CON3232BLink David J · Helena, MTN3233ZGelvin Stanley M · Central, AKN3234LTarrant County College · Fort Worth, TXN3236BSoderman David W · Gilby, NDN3238ZZulu Flight LLC · Washougal, WAN3239ZRoach Aviation LLC · Longview, TXN3241PBravo Partners LLC · Payson, AZN3242BLannom Tony F · Fort Davis, TXN3244BSharon Enterprises LLC · Peralta, NMN3244ZGinn Robert Theron · Royston, GAN3248BAgaliotis Paul E · San Martin, CAN3248PAero Spectra Corp · Boulder, CON324RTTorres Rafael · Levittown, PRN3250ZLawrence Grant Heath · Saratoga Springs, UTN3251ZCopper River Airmotive LLC · Copper Center, AKN3252PGodbout Kevin P · South Hadley, MAN3255ZBabin Joseph J · Fairbanks, AKN3256ZChristensen Robert P · Ashton, IDN325CVajdos Nicholas · Karnes City, TXN325LAPeregrine Howard Fund V Owner LLC · New Orleans, LAN325LBGlobal Aircraft Trust Inc Trustee · Cheyenne, WYN3260ZDanet Sean A · Brooksville, FLN3262BRegistered aircraftN-number assigned, not yet registeredN3263ZCaldwell Jacob A · Soldotna, AKN3264ZRyd Jan M · Lakewood, CON3267BHilgendorf Ross E · Welcome, MNN3268BJohnson Randall A · Anaconda, MTN3268POn Glideslope LLC · Middletown, DEFirst renewal noticeN326NDNational Training I LLC · Wilmington, DEN3270ZWhite Glenn A · Timber, ORN3271BOchs Robert D · Saint Louis, MON3271ZModra Anthony K · Fredonia, WIN3273BHultsch Kevin C · Lockport, ILN3273ZWeber John D · Shelbyville, ILN3274ZHeide Jeffrey J · Kenosha, WIN3276PFly Rite Aviation LLC · Fort Myers, FLN3277ZBacklund Scott W · Greybull, WYFirst renewal noticeN3278BAllen Craig S · Hico, TXN3278YMiddle Tennessee State University · Murfreesboro, TNN3279PSouth Bay Flight Training Center · Carolina, PRN3280PRiggin Flight Service Inc · Madison, SD
Back to AD 85-02-05 R1