Skip to content

Registered aircraft · 728

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:81-23-01-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:81-23-01-R1') 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:81-23-01-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:81-23-01-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:81-23-01-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:81-23-01-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.

N90PHTriple R Spraying LLC · Dumas, TXBuilt 1973 · S/N LW-60 N90TJTalcorp Ec Inc · Justin, TXS/N LW-228 N90WJDodson International Parts Inc · Rantoul, KSBuilt 1971 · S/N LJ-525 N90WLUniversity Of Maryland Eastern Shore · Princess Anne, MDBuilt 1969 · S/N LJ-461 N911CXCentral Virginia Aviation Inc · Petersburg, VABuilt 1979 · S/N LJ-830 N911FNApollo Aviation LLC · Las Vegas, NVBuilt 1976 · S/N LJ-688 N911PYOrchtrans Inc Trustee · Wilmington, DEBuilt 1960 · S/N LF-21 N915CDN915cd LLC · Woodland, CABuilt 1977 · S/N LJ748 N918MRMarc Aircraft Holding LLC · Soldotna, AKS/N LM-138 N918SAThiel Air Care Inc · Chowchilla, CABuilt 1980 · S/N LJ918 N918VSDodson International Parts Inc · Rantoul, KSBuilt 1976 · S/N LW-200 N91KABank Of Utah Trustee · Salt Lake City, UTS/N LJ-1232 N91RKAir Flight Inc · Fort Lauderdale, FLBuilt 1976 · S/N B-226 N91SDynamic Avlease Inc · Bridgewater, VABuilt 1972 · S/N LU-15 N923CRWc&R LLC · Austin, TXBuilt 1984 · S/N LJ-1074 N925ARRnjs Products LLC · Lewes, DEBuilt 1977 · S/N LJ-725 N92BDynamic Avlease Inc · Bridgewater, VABuilt 1970 · S/N LM-132 N92DVMile Hi Skydivers Inc · Longmont, COS/N LW-292 N92JDynamic Aviation Group Inc · Bridgewater, VAS/N LU-12 N92SCalcasieu Parish Jury Mosquito Control · Lake Charles, LAS/N LU-05 N930KThree Zero Kilo LLC · Costa Mesa, CABuilt 1967 · S/N LJ-294 N93ABernhard Leasing LLC · Ashland, OHBuilt 1973 · S/N LW-63 N93GTDodson International Parts Inc · Rantoul, KSBuilt 1974 · S/N B-179 N93JDynamic Avlease Inc · Bridgewater, VABuilt 1970 · S/N LM-128 N93LPKenmore Crew Leasing Inc Trustee · Bellingham, WAS/N LJ-901 N93SFArctic Legacy Aviation LLC · Anchorage, AKBuilt 1976 · S/N BE-13 N93VDynamic Aviation Group Inc · Bridgewater, VAS/N LU-03 N93VDAbsl Construction · Hayward, CABuilt 1972 · S/N B-118 N93WTWes Tex Drilling Company · Abilene, TXBuilt 1979 · S/N BE-80 N944KCarmine Labriola Inc · Scarsdale, NYBuilt 1969 · S/N LJ-467 N944TFCornerstone Leasing Of The Texas Panhandle LLC · Panhandle, TXBuilt 1976 · S/N LW-177 N946AMGuardian Flight Holdings Inc · Fairbanks, AKBuilt 1978 · S/N LJ-815 N948HBNew Mountain Aviation LLC · Englewood, COBuilt 1980 · S/N BE-98 N94CDSteel Clad Inc · Greenville, SCBuilt 1980 · S/N LJ-939 N94HBVms Aviation Services LLC · Ardmore, OKBuilt 1980 · S/N LJ-904 N94NDynamic Avlease Inc · Bridgewater, VAS/N LU-04 N94SDynamic Avlease Inc · Bridgewater, VABuilt 1971 · S/N LM-133 N950AAAlpine Aviation Inc · Provo, UTBuilt 1974 · S/N U-159 N953RCRmc Aviation LLC · Trumann, ARBuilt 1980 · S/N BE-94 N9546QNasair Aviation Services LLC · West Long Branch, NJBuilt 1966 · S/N LC-231 N958JHAims Community College · Greeley, COS/N LJ-1108 N95LBTate James D · Christiansted, VIS/N LW-24 N95SDynamic Avlease Inc · Bridgewater, VABuilt 1971 · S/N LM-125 N95WAAlpine Aviation Inc · Provo, UTBuilt 1968 · S/N U-6 N963KAMeshoppen Air LLC · Tunkhannock, PABuilt 1977 · S/N LW242 N964GBTango Papa Whiskey LLC · Manchester Center, VTBuilt 1981 · S/N LJ-1007 N965LGGoody Birds LLC · Prattville, ALBuilt 1976 · S/N LW-204 N96AGSouthern Star Aviation LLC · Missoula, MTBuilt 1967 · S/N LJ-260 N96SDynamic Avlease Inc · Bridgewater, VABuilt 1970 · S/N LU-13 N96YDynamic Avlease Inc · Bridgewater, VABuilt 1970 · S/N LU-8

Back to AD 81-23-01 R1