AD 2000-09-06
Registered aircraft · 1,273
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-09-06')
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-09-06')
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-09-06') 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-09-06') 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.
N12031Burnett Brandon Ryan · White Lake, MIN12032Riebe Robert D · Caldwell, IDN120AGHallmark Ronald D · Spring Hill, TNN120GBug Air LLC · Anchorage, AKN1211MArchangelair LLC · Wilmington, DEN122CPFlorida Seaplanes LLC · Altamonte Springs, FLN122WANagle Derek T · Ada, MIN123MGHagedorn Aviation Inc · Columbus, OHN123PPHyman Martin Am · Saunderstown, RIN123SPMain Wesley Jake · Kenai, AKN123VAKarinen Joel J · Anchorage, AKN124CHSpearhead Aviation Inc · Parker, CON125ABTkc Aviation LLC · York, SCN125HSHenderson State University · Arkadelphia, ARN126CMSouthern Aircraft Consultancy Inc Trustee · Casper, WYN126DPGuedon Air LLC · Natchez, MSN1275VCarney George R · Apple Valley, CAN127CPHatfield David E Trustee · Bangs, TXN128CPMaule Flight Inc · Moultrie, GAN128DHMorris Thomas E · Orlando, FLN129CPUpright Aviation LLC · Helena, MTN12BEElliott Russell R · Wasilla, AKN12LPBlewett John Thomas Jr · Springfield, GAN12PGGrimes Richard J · Greenville, MIN12VRCulver Lane M · Laceys Spring, ALN1300PHerzog Gregory L · Star, IDN131CPFlorida Seaplanes LLC · Altamonte Springs, FLN131PHMori Glenn E · West Ossipee, NHN134CPHoughton Lewis · Waxhaw, NCN136CPMaule Flight Inc · Moultrie, GAN136HSHenderson State University · Arkadelphia, ARN138CPPlumstead Lawrence · Seminole, FLN139CPLai LLC · Pearl, MSN13PZCroft Jordan · Rosamond, CAN13ZF13zf LLC · Bend, ORN141AREpp Robert Jackson · New Kent, VAN141DFNaumann Reuben D · Blackwell, MON141RSFrederick Investment Corp · Raleigh, NCN141WFSouthern Aircraft Consultancy Inc Trustee · Casper, WYN142BESugar Pop Group LLC · Saco, MEN142CPMasters Michael David · Blue Ridge, GAN143BHTappan Holdings Inc · Cadiz, OHN143JDHarris Steven V · Springtown, TXFirst renewal noticeN143SDWhiskey Fox Group LLC · Destin, FLN1474Loon Mountain Aviation LLC · Mccall, IDN147WMSouthern Aircraft Consultancy Inc Trustee · Casper, WYN148DPHenke Kristen C · Bettendorf, IAN14HFSkopek Darin A · River Falls, WIN14LMFeuerborn Ethan · Boise, IDN152HSHenderson State University · Arkadelphia, AR
Back to AD 2000-09-06