Skip to content

Registered aircraft · 80

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:2012-21-06') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-21-06') 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:2012-21-06')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-21-06')
  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:2012-21-06')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-21-06')
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.

N100GP100gp LLC · Wilmington, DEBuilt 2011 · S/N LJ-2007 N10GFBank Of Utah Trustee · Salt Lake City, UTBuilt 2009 · S/N LJ-1970 N11Federal Aviation Administration · Oklahoma City, OKBuilt 2009 · S/N LJ-1964 N118GTWright Jeffry William Trustee · Milford, DEBuilt 2014 · S/N LJ-2118 N12Federal Aviation Administration · Oklahoma City, OKBuilt 2009 · S/N LJ-1966 N121MFMercy Flights Inc · Medford, ORS/N LJ-2144 N12WEN12we LLC · Lewes, DES/N LJ-1893 N13Federal Aviation Administration · Oklahoma City, OKBuilt 2009 · S/N LJ-1968 N14Federal Aviation Administration · Oklahoma City, OKBuilt 2009 · S/N LJ-1972 N149MFMercy Flights Inc · Medford, ORBuilt 2018 · S/N LJ-2151 N158JMad River LLC · Lenox, MABuilt 2007 · S/N LJ-1859 N159ZZBrown Helicopter Inc · Pensacola, FLBuilt 2010 · S/N LJ-1991 N16Federal Aviation Administration · Oklahoma City, OKBuilt 2010 · S/N LJ-1994 N17Federal Aviation Administration · Oklahoma City, OKBuilt 2012 · S/N LJ-2052 N227GAJavid LLC · Buckhannon, WVBuilt 2009 · S/N LJ-1927 N23NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2009 · S/N LJ-1944 N266BCBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N LJ-2066 N267HBAirbridge One LLC · Opelika, ALBuilt 2013 · S/N LJ-2067 N26NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2009 · S/N LJ-1956 N2NCN C Dept Of Transportation · Raleigh, NCBuilt 2007 · S/N LJ-1855 N3133LBank Of Utah Trustee · Salt Lake City, UTBuilt 2008 · S/N LJ-1873 N320KAKismet Aviation LLC · Oldenburg, INBuilt 2010 · S/N LJ-1985 N324JPRm Aviation LLC · Davenport, IABuilt 2008 · S/N LJ-1921 N32PZRadiopharmacy Regional Air Services LLC · Tempe, AZBuilt 2011 · S/N LJ-2035 N330PEUnd Aerospace Foundation · Grand Forks, NDBuilt 2008 · S/N LJ-1917 N33QCQuality Castings Co Inc · Orrville, OHBuilt 2014 · S/N LJ-2108 N342PBOrchard Machinery Corp · Yuba City, CABuilt 2009 · S/N LJ-1960 N353KQKugler Oil Co · Mccook, NEBuilt 2010 · S/N LJ-1989 N363YWBank Of Utah Trustee · Salt Lake City, UTS/N LJ-1903 N365JCGreen Flash Ventures LLC · Newport Beach, CABuilt 2012 · S/N LJ-2057 N38HLTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2008 · S/N LJ-1914 N400BKMel Hambelton Ford Inc · Wichita, KSBuilt 2012 · S/N LJ-2058 N412WCElevation Aviation Services LLC · Aurora, ORBuilt 2008 · S/N LJ-1916 N43GNFlt Level LLC · Missoula, MTBuilt 2010 · S/N LJ-1992 N448CREdwards Mt LLC · Visalia, CABuilt 2013 · S/N LJ-2082 N461RGNew Pig Corp · Tipton, PABuilt 2012 · S/N LJ-2040 N471VYBank Of Utah Trustee · Salt Lake City, UTBuilt 2009 · S/N LJ-1957 N484BWAero Western Logistics LLC · Goshen, CAS/N LJ-1883 N49MJBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N LJ-2109 N505DKBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N LJ-2071 N567WRefrigeration Supplies Distributor · Lake Forest, CABuilt 2018 · S/N LJ-2159 N610SGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2010 · S/N LJ-2001 N6211JRk Tn Investments LLC · Rushville, INBuilt 2009 · S/N LJ-1931 N6449BRegistered aircraftBuilt 2009 · S/N LJ-1949 N654AFTexas A&M Concrete LLC · Houston, TXBuilt 2008 · S/N LJ-1905 N65MVAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2008 · S/N LJ-1870 N685GSGhavi Enterprises Inc · Kenosha, WIS/N LJ-2097 N68NTUnion Air LLC · Searcy, ARBuilt 2013 · S/N LJ-2092 N69VGMontana First Coil LLC · Helena, MTBuilt 2013 · S/N LJ-2089 N715GC6ts Holdings LLC · Mineola, TXBuilt 2012 · S/N LJ-2039

Back to AD 2012-21-06