AD 2000-23-21
Registered aircraft · 47,138
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-23-21')
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-23-21')
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-23-21') 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-23-21') 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.
N32HCDrake Sr22 LLC · Franklin, NCN32HGGlauser Aviation LLC · Houston, TXN32HWStrader John Kelly · Brenham, TXN32JGBlackbird Florida LLC · Deerfield Beach, FLN32MBMarin Airmen Inc · Mill Valley, CAN32MCCook Tracy L · Prosper, TXN32MFHistick Logistics LLC · Camden, DEN32MZRegistered aircraftN32NBSteele Kathleen N · Scottsdale, AZN32PLDiette Paul S · Middlebury, VTN32PPDenison Aviation Inc · Atlantic, IAN32PXKustatan Leasing LLC · Kenai, AKN32RLVb Glass Company Inc · Jamestown, CAN32TCarolina Blue Aviation LLC · Villanova, PAN32TAVan Wyk Kenneth W · Pella, IAN32TBBoyland Todd · Solon, OHN32TLJonesboro Cycle And Atv LLC · Bone, ARN32VSpeer Aviation LLC · Evansville, INN32VACommonwealth Of Virginia · Richmond, VAN32VSCraftline LLC · Delray Beach, FLN32WBFly Away LLC · Aguanga, CAN32WHEagle Air Partners LLC · Bartlett, TNN32ZGSky 4 Holdings LLC · Kaysville, UTN32ZZJp Lemke Aviation LLC · Jenison, MIN3300AAdams Air & Sea Inc · Wilmington, DEN3300FCarter Flygare Inc · Sacramento, CAN3300GAir Amg LLC · Greensboro, NCN3300YRaulston Electric LLC · Bagwell, TXN33012Leon Hinkle LLC · Fort Ashby, WVN3301DJohnson Peter L · Chico, CAN3301RJuliet Zulu Holdings LLC · Dover, DEN3302YFoster James R · Mcpherson, KSN3303YWoolery David W Jr DBA · Lathrop, MON3304FStephan Pamela K · Anchorage, AKN3304QMcnutt Brian K · Mojave, CAN3304XPhillips Daniel J · Argusville, NDN3305Erwin Matthew L · Georgetown, INN3305RLivingston Sonja L · Redding, CAN3305YWolfe Randall S · Wasilla, AKN3306DAlquist Kevin B · Edwardsville, KSN3306QTwin G Aviation LLC · Charlotte, NCN3306UMartin Paul R Jr · Greensboro, GAN3306YSaunders Craig · Spring Hill, FLN33071Krogstad Bruce H · Milwaukee, WIN3307RPhan Tam M · Charlotte, NCN3307UPatronyk Gregory M · Santa Barbara, CAN3307XMathison John M · Vancouver, WAN3308FBravo Hotel LLC · Lewes, DEN3308RLocatelli Gabriel G · North Bend, ORN3308SSutton Aircraft Salvage LLC · Palmer, AK
Back to AD 2000-23-21