Registered aircraft · 924

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:83-22-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:83-22-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:83-22-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:83-22-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:83-22-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:83-22-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.

N902MTAircraft Trustee Services Inc Trustee · Dover, DES/N 27-8054038 N90346Mittelsted John J · Dickinson, TXBuilt 1967 · S/N 27-3604 N90EFBardoo Sean L · Massapequa, NYBuilt 1976 · S/N 27-7654081 N91119Sky Ocean Group LLC · Lewes, DES/N 27-4121 N914CCJ&W Racing And Aviation LLC · Port Saint Lucie, FLBuilt 1967 · S/N 27-3769 N916DPGalliot Bond LLC · Atlanta, GAS/N 27-7654183 N924CCSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1966 · S/N 27-3490 N927PTReds Asset Managers LLC · Pottsville, PABuilt 1976 · S/N 27-7754008 N92BCRobert Craig LLC · Wilmington, DEBuilt 1995 · S/N 27-4823 N92DMD & M Flyers LLC · Petoskey, MIBuilt 1978 · S/N 27-7854107 N930MDTab Associates Inc DBA · Port Saint Lucie, FLBuilt 1967 · S/N 27-3787 N93MVWell Bilt Industries USA LLC · Ocala, FLBuilt 1979 · S/N 27-8054029 N952ANAztec 66 LLC · Indianapolis, INBuilt 1965 · S/N 27-2862 N957SSkymark Airlines · Sacramento, CARegistration revokedBuilt 1962 · S/N 27-2136 N959CVaero Inc · Vinton, VABuilt 1981 · S/N 27-8154029 N95TKTalos Aviation Group LLC · Blackstone, VABuilt 1970 · S/N 27-4555 N964MMModular Aviation LLC · Saratoga Springs, UTBuilt 1978 · S/N 27-7854132 N976AZWl Aviation LLC · Boca Raton, FLBuilt 1976 · S/N 27-7654200 N98PPMedia Stew LLC · Carson City, NVBuilt 1965 · S/N 27-2872 N9974FShipp G Carl Md · Little Rock, ARS/N 27-4835 N998FBRegistered aircraftN-number assigned, not yet registeredS/N 27-440 N9999WScudder Adam · Orlando, FLBuilt 1976 · S/N 27-7654086 N99FPShort Jon P · Cullman, ALFirst renewal noticeBuilt 1978 · S/N 27-7854119 N9APWellsville Flying Service Inc · Wellsville, NYS/N 27-7305129

Back to AD 83-22-01 R1