Registered aircraft · 1,770

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:2018-03-03-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:2018-03-03-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:2018-03-03-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:2018-03-03-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:2018-03-03-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:2018-03-03-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.

N903CAHyannis Air Service Inc DBA · Hyannis, MABuilt 1979 · S/N 402C0047 N903JDAirventure LLC · Fort Lauderdale, FLS/N 421C0420 N904BCFox 3 Partners LLC · Virginia Beach, VABuilt 1981 · S/N 421C1027 N9063MThompson Anthony · Miami, FLBuilt 1971 · S/N 402B-0105 N909AAKings Wings Inc · Jupiter, FLBuilt 1968 · S/N 401-0227 N909RFPastjo Aviation LLC · Charleston, WVBuilt 1982 · S/N 414A0840 N90MKBs LLC · Huntsville, TXBuilt 1977 · S/N 421C0282 N90YAPlane Brilliant LLC · New Port Richey, FLS/N 425-0090 N91045Dakota Aircraft Specialists LLC · Hot Springs, SDBuilt 1975 · S/N 414-0623 N915LPLee Flight Services LLC · Davie, FLS/N 421B0572 N918BVDietz John W Jr · Westfield, INBuilt 1982 · S/N 421C1247 N919CBCatclaw Aviation LLC · San Antonio, TXBuilt 1981 · S/N 414A0672 N919FAFortnum Air LLC · Dana Point, CAS/N 414A0628 N91TWPistol Aviation LLC · Stillwater, OKBuilt 1978 · S/N 414A0117 N921AJAerohippo Corp · Franklin Lakes, NJBuilt 1974 · S/N 421B0613 N922ASSchool Of Missionary Aviation Technology · Ionia, MIS/N 414-0033 N922KVKings Oil Tools Inc · Paso Robles, CABuilt 1981 · S/N 425-0052 N925BKAcom Electronic Measurement Technology Inc · Milpitas, CABuilt 1976 · S/N 0117 N926MTNew London Aviation LLC · Forest, VABuilt 1978 · S/N 421C0625 N928DMEllis Leven Handy IV Trustee · Champions Gate, FLS/N 421B0835 N929HBSaratoga Transporation LLC · Encino, CAS/N 414-0509 N92CVRandall Grier Ministries · Owasso, OKBuilt 1984 · S/N 421C1065 N92DFN92df Slo LLC · Arroyo Grande, CAS/N 421C0889 N92PSMeshoppen Air LLC · Tunkhannock, PABuilt 1971 · S/N 421B0134 N934CRReygar Investments LLC · Brownsville, TXBuilt 1982 · S/N 414A0856 N936AFVasquez Ahyde E · Brownsville, TXS/N 421C0606 N9414ARitchie Race S · Odessa, TXS/N 414A0267 N942SWVascoe Jeffre M · Houston, TXBuilt 1981 · S/N 421C1025 N945BGDavis James H · Corpus Christi, TXBuilt 1980 · S/N 421C-0870 N94RWWithers Dana Ruth Executor · Mount Vernon, ILBuilt 1981 · S/N 414A0662 N954MCBank Of Utah Trustee · Salt Lake City, UTBuilt 1975 · S/N 421B0891 N959RHRd Holdings LLC · Las Vegas, NVBuilt 1978 · S/N 414A0217 N959TXAhern John · Prosper, TXBuilt 1977 · S/N 414A0011 N95GMMeinig High Club LLC · Klamath Falls, ORBuilt 1980 · S/N 421C0821 N960DFAir Services International Leasing LLC · Fort Lauderdale, FLBuilt 1979 · S/N 414A0444 N960EMCowboy Up Aviation LLC · Fort Worth, TXBuilt 1974 · S/N 421B0881 N974CFAviation Trust Company LLC · Oklahoma City, OKBuilt 1974 · S/N 421B0609 N977BHMotors Inc · Cumming, GAS/N 421C0227 N977SMKmc Aviation Leasing LLC · Indianapolis, INBuilt 1974 · S/N 421B0595 N97DHEmbry Aero Ltd · Greenville, ILBuilt 1978 · S/N 421C0450 N97JKAviation Trust Company LLC Trustee · Oklahoma City, OKBuilt 1978 · S/N 414A0052 N98437Infranco Anthony · Amityville, NYBuilt 1975 · S/N 421C0040 N98649Dodson International Parts Inc · Rantoul, KSBuilt 1977 · S/N 402B1030 N98697Gimli Son LLC · Fort Lauderdale, FLS/N 402B1053 N986GMGospel Ministries International Inc · Collegedale, TNBuilt 1978 · S/N 414A0089 N98725First Flight Corp · San Diego, CABuilt 1976 · S/N 414-0824 N9873FAirswiss Inc · Wilmington, DEBuilt 1968 · S/N 402-0303 N987MCTwa LLC · Weatherford, OKFirst renewal noticeBuilt 1977 · S/N 421C0439 N989AAMouat Brian · Trent Woods, NCS/N 401A-0042 N98CEQueen Aviation LLC · Wilmington, DEBuilt 1978 · S/N 414A0066

Back to AD 2018-03-03 R1