AD 2000-25-02 R1
Registered aircraft · 7,563
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-25-02-R1')
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-25-02-R1')
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-25-02-R1') 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-25-02-R1') 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.
N6020VWiethoff Kent · Fairfax, MNN602ZCook Innovative Enterprises LLC · Missoula, MTN6035VFugleberg Richard H · Mayville, NDN6039VDykstra Wayne · Pipestone, MNN6040VMoser Mark W · Wooster, OHN6041VFenton Harry L · Rockton, ILN6045VLee Levi A · East Gull Lake, MNN6058CWeaver Douglas L · Kasilof, AKN6059VWilliams William O · Oswego, ILN607ECEverts Air Service Inc · Sarasota, FLN6084VElmore Jerry R Jr · Wichita, KSN6085VObrien Stephen F · Manley, AKN6093CHansen Evan P · Stevens Point, WIN6096FColeman Gregory M · Chewelah, WAN60ACHaas Brent R · Willcox, AZN60FUR & N Associates World Wide Inc · Port Orange, FLN60JBHarmon Eagle LLC · Albuquerque, NMN60LRBlake W Preston · Gainesville, FLN60SGRichard Amster · Brookline, MAN60XDIron Air LLC · Saint Albans, MON61167Stout Terry P · Martinez, GAN611APDobry Robert S · Crescent City, FLN611DXRegistered aircraftN611KRhode Kyle D · Orlando, FLN612APThomas Lucas G · Beebe, ARN6133HCbc Aviation LLC · Hayden, IDN613APThomas Lucas G · Beebe, ARN613KBPrecision Aero LLC · Wilmington, DEN613PCPrivitt Bret J · Forest Hill, TXN614ACLawless Aviation LLC · Fishers, INN614MATwinair LLC · Junction City, WIN615DDShady Aviation LLC · Beebe, ARN615JSPollak Steven D · Cincinnati, OHN615MADowling Thomas · Mechanicville, NYN617MAAs The Crow Flies LLC · Belmont, WIN617WWood Jim · Seminole, TXN6180ZZeliff Aviation LLC · Batavia, NYN618JKAiuto James J · Sterling Heights, MIN61980Guerin Bryant J · West Ossipee, NHN61ALOwens John R · Lexington, KYN61BDFrazier Brian Donald · Jackson, MSN61DAUrban Aviation Services Inc · Paxton, MAN61JGMac Air Inc · Farmington, MON61PBGarlington Grant E · Tulsa, OKN61RE3d Aviation LLC · Aliso Viejo, CAN61SEBase III LLC · Winnetka, ILN6203KDeleon-Muniz Mario Antonio · Hemet, CAN6208LReeve Howard E · Minot, NDN6213NDexter Fred H · Live Oak, FLN621EHofstetter Michael T · Saint James, MO
Back to AD 2000-25-02 R1