AD 2000-02-30
Registered aircraft · 270
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-02-30')
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-02-30')
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-02-30') 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-02-30') 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.
N690ASAero Commander N690as LLC · Kalispell, MTN690AWPeter Claire Pty Ltd · GeorgetownN690AXPia Avcenter LLC · Peoria, ILN690BGN690bg LLC · San Angelo, TXN690BHHoward Bradley D · Big Sky, MTN690BMCommander 690 Bm LLC · Manassas, VAN690CCTj Air Holdings Inc Trustee · Wilmington, DEN690CFN A Corp · Scappoose, ORN690CHElecrock LLC · Bay City, WIN690CPPonderosa Aviation LLC · Safford, AZN690DDTropeano Construction Inc · Ocala, FLN690EHSanborn Map Company Inc · Colorado Springs, CON690FDPonderosa Aviation LLC · Safford, AZN690GFBank Of Utah Trustee · Salt Lake City, UTN690HBPonderosa Aviation LLC · Safford, AZN690HFRegistered aircraftN690JKSpur Aviation Services Lc · Twin Falls, IDN690LNSanborn Map Company Inc · Colorado Springs, CON690PKMilou 1 LLC · New York, NYN690PTCritical Mass Aviation LLC · Coral Springs, FLN690RAMountain Aviation Enterprises LLC · Safford, AZN690RJAir Prometheus LLC · Santa Fe, NMN690SDWoodward Properties LLC · Kalispell, MTN690SESkyline Enterprises Corp · Miramar, FLN690SGNeptune Aviation Services Inc · Missoula, MTN690TGNeptune Aviation Services Inc · Missoula, MTN690TRKolob Canyons Air Services Inc · Wilmington, DEN690WS69 Whiskey LLC · Nezperce, IDN692TKaskel Super Service LLC DBA · Evansville, INN695CSCourtney Aviation LLC · Columbia, CAN695FABank Of Utah Trustee · Salt Lake City, UTN695GHN695gh Inc Trustee · Wilmington, DEN695GKGulfstream Aviation LLC · West Glacier, MTN695JHCommander LLC · Sun Valley, IDN695JPGulfcomm 1000 LLC · Matthews, NCN695MMM8 Aviation LLC · Raleigh, NCN695RCCapital Aviation II LLC · Bethesda, MDN695RTCommander Sc LLC · Mount Pleasant, SCN695TRRainey Air LLC · Bronwood, GAN695ZSanborn Map Company Inc · Colorado Springs, CON699SBMeginnis Thomas O · Omaha, NEN700PQPia Avcenter LLC · Peoris, ILN708PCAustin Point Aviation LLC · Portland, ORN711PBSpur Aviation Services Lc · Twin Falls, IDN71AAFlying A Flight Service LLC · Safford, AZN721TBTeton Leasing LLC · Pocatello, IDN742WAirborne Holdings Inc · Midlothian, TXN74EF3bk Source LLC · Wellington, FLN750RGHmcs LLC · Charlotte, NCN751BRPonderosa Aviation LLC · Safford, AZ
Back to AD 2000-02-30