Skip to content

Registered aircraft · 47,133

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

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

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.

N3501SRynearson John L Trustee · Scottsdale, AZBuilt 2006 · S/N 41588 N3501UN3501u LLC · Tulsa, OKBuilt 1963 · S/N 18254901 N3502FLange Clifton E · Inez, TXBuilt 1966 · S/N 18257502 N3502UStreamline Business Management · Citrus Heights, CAS/N 18254902 N3503YNorthern Lights Renewables LLC · Condon, MTS/N 18254403 N3504FBraden Peter S · Elizabethtown, KYBuilt 1966 · S/N 18257504 N3504YThigpen Alec DBA · Spanish Fort, ALBuilt 1962 · S/N 18254404 N3505FWade Bradley S · Waterman, ILBuilt 1966 · S/N 18257505 N3507YAyers Curtis W · Greenback, TNBuilt 1962 · S/N 18254407 N3508FStephen G Dill Dvm LLC · Remington, VABuilt 1966 · S/N 18257508 N3509UGarrett Robert L · N Richland Hills, TXBuilt 1963 · S/N 18254909 N3509YAnderson Kevin · Verona, NDBuilt 1962 · S/N 18254409 N350ABierlein Aviation LLC · Midland, MIBuilt 1977 · S/N 340A0325 N350BShaffer Benjamin C · Adair, OKBuilt 1957 · S/N D-4905 N350BLAustin Neal · Fort Myers, FLBuilt 2003 · S/N 42006 N350BTAeroventure LLC · Middletown, DEBuilt 2006 · S/N 42537 N350CHFly Bye LLC · Georgetown, DEBuilt 1973 · S/N 310Q0910 N350CTMaas Karl G · La Crosse, WIBuilt 1966 · S/N CE-14 N350CWPrivate Flight LLC · Wilmington, DEBuilt 2006 · S/N 42520 N350DGQualitair LLC Trustee · MichelstadtBuilt 2005 · S/N 42074 N350ELCowick Glen M · Hollister, CABuilt 2001 · S/N ES-016-FB N350FJHafer Randall Frederick · Marietta, GABuilt 2008 · S/N 421008 N350FUAmerican Airpower Heritage Flying Museum · Dallas, TXBuilt 1951 · S/N NAV-4-2287BF N350GMCannonball Trucking Inc · Houston, TXBuilt 1978 · S/N 414A-0120 N350GZValiair Lc Trustee · Casper, WYBuilt 1979 · S/N P21000382 N350JCWear On Earth Aviation LLC · Potsdam, NYBuilt 1975 · S/N 310R0606 N350LCDaly Arthur P · El Paso, TXBuilt 1978 · S/N P21000049 N350NEMaresco International Corp · Alpha, NJBuilt 1980 · S/N D-10351 N350NWBas Part Sales LLC · Greeley, COBuilt 1977 · S/N CE-753 N350PGGuerra Michael E · Kerrville, TXBuilt 2003 · S/N 42005 N350RPShy Dennis · Cape Coral, FLBuilt 2004 · S/N 42046 N350SDAmerican Aircraft Sales LLC · Lincolnshire, ILBuilt 1970 · S/N 310Q0065 N350SFTakamatsu Hiroaki · Redmond, WAS/N 42062 N350SLNeenair LLC · Danville, VABuilt 2006 · S/N 42526 N350TBStephenson Richard J Trustee · Wheeling, ILBuilt 1973 · S/N E-413 N350TMJefferies Stanley J · Coos Bay, ORBuilt 1969 · S/N 21059125 N350YRSilverman Kenneth · Pelham, NHBuilt 1982 · S/N D-10383 N350ZLander Maritza C · Key Biscayne, FLBuilt 1960 · S/N CD-236 N3510FHughes Ramzi Sanford · Alamo, NVBuilt 1966 · S/N 18257510 N3511VCypress Creek Shooting Lodge LLC · Greenbrier, ARBuilt 1980 · S/N D-10353 N3511YJ F Jones Logistics LLC · Dallas, TXBuilt 1962 · S/N 18254411 N3512FNourbakhsh Illah R · Pittsburgh, PABuilt 1966 · S/N 18257512 N3512UN3512u LLC · Ruidoso, NMBuilt 1963 · S/N 18254912 N3513UDieck Michael N · Raleigh, NCBuilt 1963 · S/N 18254913 N3514FSullivan Kelly J · Chandler, AZBuilt 1966 · S/N 18257514 N3514MCooley David Alan · Harrod, OHBuilt 1978 · S/N 28R-7803175 N3514YCielakie Edward W · Dracut, MABuilt 1962 · S/N 18254414 N3515USchettler Patrick J · Garnett, KSS/N 18254915 N3515YInflyt LLC · Carlsbad, CAS/N 18254415 N3516FWhittock Tyson H · Anchorage, AKBuilt 1966 · S/N 18257516

Back to AD 2000-23-21