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.
N9318EAirpower Museum Inc · Ottumwa, IAN9324EAnderson Timothy H · Janesville, WIN9325HBrown Richard S · Moon Township, PAN9327HBealer David C · Bethlehem, PAN9328ERichie James A · Pleasant View, TNN9329EVan Winkle Randy M · Van Buren, MON9330HHrutkay Charles S · Scenery Hill, PAN9331ECimprich Joseph P · Camden, OHN9333EObrien Stephen F · Manley Hot Springs, AKN9334ELisch Timothy F · Delavan, WIN9336EWagner Dean M · Bellevue, WAN933BCPathak Rahul · Mercer Island, WAN9342EWilson Kenneth D · Warsaw, MON9344EDodd Jason R · Pittsboro, INN9345EGundersen Paul M · Polson, MTN9346EBarthule Jacob E · Roundup, MTN9349ELittle Colin J · Bidwell, OHN9351EBrown David L · Hicksville, OHN9354EMilheim Charles J · Watsontown, PAN9355ELurie Allan H · Peoria, ILN9357EWelling Charles E III · West Islip, NYN9361ERodkey John R · Goleta, CAN9365EHoskins Robert · Castalian Springs, TNN9367EBracken Phillip C · Frostproof, FLN9369ELin Andrew H · Huntingtown, MDN93711Perkins Herbert A · Kerrville, TXN9371EOrf Christopher D · Saint Peters, MON9373EFrick Gary A Trustee · Marion, INN9381EHeavirland Patrick J · Roseville, MNN9382ESale Reported · Westmoreland, TNSale reportedN9384EHaley Billie Jo · San Martin, CAN9388EHendrix Charles K Jr · Dyersburg, TNN939ABTractorboyflys LLC · Sugar Land, TXN939CBRegistered aircraftN93ACGwidt Mitchell A · Prior Lake, MNN93BCThorp Contractors LLC · Vinita, OKN93BYPearce Ricky A · Parsons, KSN93DNRiseaero LLC · Florence, SCN93DTTolkach Dennis · Dunlevy, PAN93GFRanieri Realdo · Mesa, AZN93SMVilla Aviation LLC · Alpharetta, GAN93WEBoeing Employees Flying Assoc · Renton, WAN93WKPiercy Ronald S · Moses Lake, WAN9401EBurns Fletcher A · Heathsville, VAN9404EMaloney Edward M · Coloma, MIN9405EFenger Paul L · Cottonwood, MNN9410ELopez Jesus · Cicero, ILN9411ESky West Aviation Inc Trustee · Albuquerque, NMN9416EAllen George C · Upper Lake, CAN9417EKuhn Darrell G · Irma, WI
Back to AD 2000-25-02 R1