Registered aircraft · 129

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:90-03-07-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:90-03-07-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:90-03-07-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:90-03-07-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:90-03-07-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:90-03-07-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.

N900VPJdr 194 LLC · Woody Creek, COBuilt 2002 · S/N 194 N900YBBold Access LLC · Leawood, KSBuilt 1987 · S/N 18 N900YYBbps Aviation LLC · Mckinney, TXBuilt 1991 · S/N 101 N901KRAvatar Wings LLC · Dallas, TXBuilt 1994 · S/N 146 N905FJTvpx Trust Co LLC Trustee · North Salt Lake, UTBuilt 1986 · S/N 5 N90FJWorldwide Aircraft Services Inc DBA · Tampa, FLBuilt 1998 · S/N 75 N90GPTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1987 · S/N 29 N90THJ & J Capital Ventures LLC · Wilmington, DEBuilt 1999 · S/N 180 N910NMTriangle Real Estate LLC · Saint Peters, MOS/N 95 N910SCSunchasing LLC · Newark, DEBuilt 1994 · S/N 144 N910TX900 Consulting LLC · Austin, TXBuilt 1998 · S/N 172 N914SSMeregrass Inc · Dublin, TXBuilt 2001 · S/N 188 N914TV1365 Swan Ridge Road LLC · New York, NYBuilt 1987 · S/N 14 N915TPGlobe Resources Group LLC · Wichita, KSBuilt 1992 · S/N 122 N917BCFlyaway Inc · Fort Worth, TXS/N 193 N917JFAdams Aviation Services Inc Trustee · Wilmington, DEBuilt 1999 · S/N 179 N918MVGuardian Aviation Services LLC · Short Hills, NJBuilt 1996 · S/N 156 N91MSLabbe LLC · Huntington Valley, PABuilt 1987 · S/N 10 N921TBBluemaxx Air LLC · Friendswood, TXS/N 85 N927BRFur Management & Consulting LLC · Junction, TXBuilt 2002 · S/N 196 N947DTTkr Aviation LLC · Ballwin, MOBuilt 1992 · S/N 117 N950SFTsl 2 LLC · Jackson, WYBuilt 1988 · S/N 50 N960CLDigital Interstate Management Inc · Keller, TXBuilt 1991 · S/N 094 N970JDFalcon Fawzi II LLC · Fort Lauderdale, FLBuilt 1992 · S/N 119 N988AKExecutive Aircraft Sales LLC · Charlotte, NCBuilt 1987 · S/N 22 N988TNext Century Aviation Oregon LLC · Sausalito, CABuilt 1988 · S/N 65 N990LTLife Time Fitness Inc · Chanhassen, MNBuilt 1988 · S/N 60 N990WRBam Aviation LLC · Jupiter, FLS/N 126 N9CUJani King International Inc · Addison, TXBuilt 1987 · S/N 19

Back to AD 90-03-07 R1