AD 2000-06-01
Registered aircraft · 39,302
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:2000-06-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:2000-06-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:2000-06-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:2000-06-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.
N111RKSan Carlos Flight Center Inc · San Carlos, CAN111RRCook David C · Orlando, FLN111SA111sa LLC · Greeley, CON111SHRobinson Doyle K · Panhandle, TXN111SRPayne John A · Bloomington, ILN111TBNeswest Inc · Los Angeles, CAN111TKMclendon Thomas A · Crockett, TXN111VFCottle John A DBA · Watsonville, CAN111WLCj Aero LLC · Fort Valley, VAN111ZUsda Forest Service · Boise, IDN111ZYSkywarrior Flight Training Inc · Pensacola, FLN11204Hudson Daryl J · Redwood Valley, CAN11208Cape Fear Aviation Maintenance LLC · Fayetteville, NCN11209Pendragon Aviation LLC · Sylvania, GAN1120DCompher Charles D · Berryville, VAN1120FHaidle Wayne M · Bismarck, NDN1120VKodiak Marine Construction · Oakley, IDN1121TWaddell Richard K Jr · Loveland, CON11226Box Jon A · Carrizo Springs, TXN11227Tribec Inc · Medina, OHN11228N11228 LLC · Wheeling, ILN1122FDollosso Frank G · Lakeport, CAN11231He Yaling · Grand Prairie, TXN11234Universal Airways Inc · Richmond, TXN11236Cato Mark M · Clemson, SCN11238Laguna Ulises Edgar · Waco, TXN1123MGrey Robert J · La Madera, NMN1123UTroy Investment Co 1 L P · Brownsville, TXN11242Crook Robert W · Wichita, KSN11243Aeronautical Technical Service Inc · Collierville, TNN1124MRegistration Pending · West Branch, MIRegistration pendingN1124QDuren Virgil W · Bristow, INN11251Air Flight Enterprises Inc · S Daytona, FLN11257Sale Reported · Eden Prairie, MNSale reportedN1125FAeropark LLC · Michigan City, INN11262Locke Brian T · Andover, KSN11268Bohl Howard M Jr · Long Beach, CAN1126CBriggs Jonathan · Merritt Island, FLN1126MD2 Government Solutions LLC · New Bern, NCN11271No Coop Cardinal LLC · Sonoma, CAN11272Williamson Brett O · Essex, MON1127FPricemeyer Aviation LLC · St Pete Beach, FLN11281Solovjev Jadranka · Sarasota, FLN11283J F Aviation Inc · Joliet, ILN11285Northeast Florida Aero Club Inc · Fleming Island, FLN11289Phelps Aero Co LLC · Salem, ORN1128CGibbs Wyatt R · Lodi, CAN1128FLockridge James · Adairsville, GAN1128UElw Inc · Bonners Ferry, IDN11290Safety In Motion Flight Center Inc · Puyallup, WA
Back to AD 2000-06-01