AD 72-03-03 R3
Registered aircraft · 17,027
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.
N6152FFisher Wayne G Trustee · Gainesville, FLN6152VClayton Stephen C · Conyers, GAN6154GGrinnell Matthew J · Auburndale, FLN6155FHalladay Roy · Erie, CON6155GChin Benny C · Chandler, AZN6155RPlane + Simple LLC · Salt Lake City, UTN6157FLa Placa Peter · Lake Havasu City, AZN6158RMahany John C · Yucca Valley, CAN615AHRusty Crate LLC · Wynne, ARN615ESCampanell Garrett · Leesburg, VAN615FUN615fu LLC · Nashville, TNN615WTOwensby Paul T · Fayetteville, NCN616U S D A Forest Service Fepp · Columbia, SCN6161FBeach Bums Air LLC · Martin, GAN6161GGough James L · Hesston, KSN6162RSmjd LLC · Penrose, CON6165FMainely Lobsters · Gulf Breeze, FLN6165GPartida Carlos · Delray Beach, FLN6167FJohnson Susan J · Chelan, WAN6169FWatrud Joel Carl · Waskish, MNN6169GKingdom Air Corps · Sutton, AKN616WERodriguez Norberto R · Inwood, NYN6170FWilkins Raymond E · Osceola, IAN6170RBrown Michael R · Huntsville, ALN6171FDohrenwend Mark G · Owensboro, KYN6171GMission Flight Academy · Yucaipa, CAN6172GTappan Scott M · Port Saint Lucie, FLN6173FLesondank Stephen M · Bellvue, CON6173RBeyer Livestock Auction LLC · Clovis, NMN6174GMosley Gabriel T · Oak Hills, CAN6175RElinoff Neal D · Telluride, CON6176RJulius Kaleb · Mesa, CON6182Olson Gary P · Lanesboro, MNN6185GJuel Thomas Gavin · Everett, WAN6187FNuxoll Builders · Clarkston, WAN6187GMiller George Chris · Lone Oak, TXN6188FSky High Adventures LLC · Wilmington, DEN6188RPeterson Bruce L · Brighton, CON6189GBrule Alan R · Crookston, MNN618WWood Jim · Seminole, TXN6192RAmbrosini Helicopters Inc · Fresno, CAN6193FRheinbolt John N · Highmore, SDN6193GHolcomb Jonathan Michael · Hollandale, MSRegistration expired, pending cancellationN6195FRegistered aircraftN6199FAcara Aviation LLC · Portage, MIN6199GPerez Joseph F · Hollywood, FLN6199RSchutte Ernest C W · Abita Springs, LAN619CHOrion Works Limited · Denali Park, AKN61JRSawyer Mark S · Simi Valley, CAN61LVHolt Daniel E Jr · Fayetteville, TN
Back to AD 72-03-03 R3