AD 2002-07-01
Registered aircraft · 3,466
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:2002-07-01')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-07-01')
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:2002-07-01') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-07-01') 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.
N6134ECf Ranch & Cattle Co LLC · Burbank, OHN6137FWingland Inc · Los Angeles, CAN6138FSchlegelmilch Scott A · Elkhorn, NEN6139BFelker Gary L · Odessa, TXN613YHKuspuk School District · Aniak, AKN6147FHenry Charles C · Portland, TNN6148FWorsham Eric S · La Porte, TXN6151YBulloch Troy P · Cedar City, UTN6152BMohave County Board Of Supervisors · Kingman, AZN6152FFisher Wayne G Trustee · Gainesville, FLN6153BCenturion Southeast Management LLC · Raleigh, NCN6153ZJaars Inc · Waxhaw, NCN6154NDouer Isaac R · Miami, FLN6155YAl & Zal Corp · Wilmington, DEN61599Freebird Aviation LLC · Eagle, IDN6160NRj Capital LLC · Mustang, OKN6161FBeach Bums Air LLC · Martin, GAN6161NOn Eagles Wings LLC · Los Gatos, CAN6163UMcevoy Steven T · Aniak, AKN6165FMainely Lobsters · Gulf Breeze, FLN6166UBb Aviation LLC · Prescott, AZN6167CSnyder Larry G · Holland, NYN6168NRegistered aircraftN6169FWatrud Joel Carl · Waskish, MNN6170FWilkins Raymond E · Osceola, IAN6170NGarmin210 LLC · Willard, MON6171FDohrenwend Mark G · Owensboro, KYN6173FLesondank Stephen M · Bellvue, CON6174BN6174b LLC · Nokomis, FLN6178WBlu Sky Key West LLC · Key West, FLN6180BNewton Raymond C Jr · Heath, TXN6180NMargiotta Russell A Trustee · Woodside, CAN6181ZDittrich James G · Anchorage, AKN6183NLewis A Everett Jr · Chico, CAFirst renewal noticeN6184CRegistered aircraftN6185BGust William J DBA · Monument, CON6187FNuxoll Builders · Clarkston, WAN6188YLexington Enterprises Group Inc · San Jose, CAN6192NDolezal Todd R · San Luis Obispo, CAN6192UKings Nw LLC · Lakewood, WAN6193FRheinbolt John N · Highmore, SDN6195BBoyd Edward Ayres · Coronado, CAN6195FRegistered aircraftN6196NMccarthy Sean P · Siloam Springs, ARN6199FAcara Aviation LLC · Portage, MIN619CHOrion Works Limited · Denali Park, AKN61DWZandri Stefano A · Ridgefield, CTN61PTWings Of Faith Ministries Inc · Tustin, CAN61RBKiazen Black Mountain Holdings LLC · Black Mountain, NCN6202BGamache Daniel S · Pleasanton, CA
Back to AD 2002-07-01