Skip to content

Registered aircraft · 22,413

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

N43ANFerrell Martin · Lubbock, TXBuilt 1980 · S/N 28-8011096 N43CSButler Bryan C · Brenham, TXBuilt 1968 · S/N 28-4641 N43DFParagon Flight Training Co · Fort Myers, FLBuilt 2024 · S/N 28020200 N43DNMurphy John R · Baltimore, MDBuilt 1972 · S/N 28-7310036 N43LCRoy Mark A · Sanger, TXBuilt 1976 · S/N 28-7790203 N43MJB2fh Ltd · Allentown, NJBuilt 1975 · S/N 28-7515297 N43PFCollum Aviation LLC · Milton, FLBuilt 1979 · S/N 28-7916362 N43WGMaxfield Kenneth B Trustee · Murray, UTBuilt 1977 · S/N 28R-7703280 N43WWMaxxum Financial Group Inc · Destrehan, LABuilt 1981 · S/N 32R-8113048 N44006Martin Seth J · Kingman, INBuilt 1977 · S/N 28-7816021 N4400ACae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2019 · S/N 2881107 N4400DCae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2019 · S/N 2881108 N4400FCae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2019 · S/N 2881139 N4400JWright James R · Red Wing, MNBuilt 1967 · S/N 28-22793 N4400PCae Oxford Aviation Academy Phoenix Inc · Mesa, AZBuilt 2013 · S/N 2843711 N4400SCae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2013 · S/N 2843712 N4400WCae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2013 · S/N 2843713 N44013Up And Down Aviation LLC · Perry, GABuilt 1974 · S/N 28-7415567 N44014Carlone Edward J · Johnson City, TNBuilt 1974 · S/N 28-7415568 N44015Phillips Charles A · Alexis, NCBuilt 1974 · S/N 28-7415569 N44017Warrior Flyers Inc · Slinger, WIBuilt 1974 · S/N 28-7405217 N4401ECae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2019 · S/N 2881141 N4401JJohary Aviation Inc · Apopka, FLS/N 28-22794 N4401NCae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2019 · S/N 2881203 N4401PCae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2019 · S/N 2881204 N4401TMcelroy Shawn · East Falmouth, MABuilt 1972 · S/N 28R-7235026 N4401UCae Oxford Aviation Academy Phoenix Inc · Mesa, AZBuilt 2019 · S/N 2881239 N4401WCae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2019 · S/N 2881240 N44027Phelps Russell C · Naknek, AKBuilt 1974 · S/N 28-7425385 N4402ACae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2019 · S/N 2881241 N4402TCae Aviation Academy Phoneix LLC · Mesa, AZBuilt 2013 · S/N 2843717 N4402UCae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2013 · S/N 2843718 N4402XGunka Jack S · Romeoville, ILBuilt 1975 · S/N 28-7615008 N44036Dorrobrook LLC · Lacey, WABuilt 1974 · S/N 28-7415572 N44037Choate Clint · Liberty Hill, TXBuilt 1974 · S/N 28-7405218 N4403JColey Shane · Statham, GABuilt 1967 · S/N 28-22796 N4403LCae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2013 · S/N 2843721 N4403TTyrrells Trails LLC · Fairbanks, AKS/N 32-7240076 N4403WCae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2013 · S/N 2843725 N4403XN4403x LLC · St Thomas, VIBuilt 1975 · S/N 28-7615009 N4403ZCae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2013 · S/N 2843726 N4404JFly Like A Girl LLC · Friday Harbor, WABuilt 1967 · S/N 28-22798 N4404PZipporah LLC · Everett, WABuilt 1963 · S/N 28-10160 N4405TDmac Aircraft LLC · Savannah, GABuilt 1972 · S/N 28-7205160 N4405XW Air LLC · Wheeling, ILS/N 28-7615011 N44060Pilatus Aircraft USA Ltd · Broomfield, COBuilt 1974 · S/N 28-7415575 N44066Majefski Waylon C · Kingwood, TXBuilt 1974 · S/N 28-7405219 N4406TPollard John R · Melbourne, FLBuilt 1972 · S/N 28R-7235034 N44076Robinson Richard · Rochester, MIBuilt 1974 · S/N 28-7415576 N4407JOsborne Kathy A · Louisville, KYBuilt 1967 · S/N 28-22801

Back to AD 87-08-08 R3