Skip to content

Registered aircraft · 5,075

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:84-19-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:84-19-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:84-19-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:84-19-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:84-19-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:84-19-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.

N8952PBreckenridge Lester James Jr Trustee · Appleton City, MOBuilt 1966 · S/N 24-4409 N8953PTendie Time Flying LLC · San Diego, CABuilt 1966 · S/N 24-4410 N8954CTeamco Aviation LLC · Saint Petersburg, FLS/N 32R-7680146 N8954NSabbagh Mouin F · Missouri City, TXBuilt 1969 · S/N 32-40757 N8954PKramer Kartie K · Mckinney, TXBuilt 1966 · S/N 24-4411 N8955NRichart Nicholas J · Clever, MOBuilt 1969 · S/N 32-40758 N8955PPropwash LLC · Princeville, ILBuilt 1966 · S/N 24-4412 N8957NN8957n Inc · Wilmington, DEFirst renewal noticeBuilt 1969 · S/N 32-40761 N8957PCreedon John · Mc Cormick, SCBuilt 1966 · S/N 24-4414 N8959PMosel Properties LLC · Marrero, LABuilt 1966 · S/N 24-4416 N8960NSkyriders Inc · Pocatello, IDBuilt 1969 · S/N 32-40771 N8961PRegistered aircraftBuilt 1966 · S/N 24-4418 N8962NGallen Peter · Wilmington, DEBuilt 1969 · S/N 32-40773 N8962PDunning John · Stow, MABuilt 1966 · S/N 24-4419 N8963NBaker Daniel T · Jackson, OHBuilt 1969 · S/N 32-40774 N8964PPerkins Michael W · Warren, MIBuilt 1966 · S/N 24-4421 N8965PChancellor Richard · Palmer Lake, COBuilt 1966 · S/N 24-4422 N8966NCherokee Six LLC · Minburn, IABuilt 1969 · S/N 32-40776 N8966PLautensack Peter · Oswego, NYBuilt 1966 · S/N 24-4423 N8969NMatanane Roke C · Barrigada, GUBuilt 1970 · S/N 32-40769 N896SJTumbleweed Aviation LLC · Great Bend, KSBuilt 1996 · S/N 46-36033 N8970PPodraza Kevin M · Dekalb, ILBuilt 1966 · S/N 24-4427 N8972PHardy Douglas · Lakewood, CABuilt 1966 · S/N 24-4429 N8973PBrockwell Derrell Randel · Oakland, TNBuilt 1966 · S/N 24-4430 N8977PWarrior Up LLC · Clayton, NCBuilt 1966 · S/N 24-4435 N8979NPeeling Clyde R · Allenwood, PABuilt 1969 · S/N 32-40862 N8980PLittle Wood LLC · Bellevue, MIBuilt 1966 · S/N 24-4439 N8982PAviation & Aerospace Consulting & Mgmt Svcs LLC · Bullhead City, AZBuilt 1966 · S/N 24-4441 N8984NBlair Gary B · Salado, TXBuilt 1969 · S/N 32-40867 N8984PMarchant Scott · Clackamas, ORBuilt 1966 · S/N 24-4443 N8985CCornelius James Sean · Hamilton, MOBuilt 1976 · S/N 32R-7680147 N8985PSharp Charles Barry · Fulton, KYBuilt 1966 · S/N 24-4445 N8986NBay Air Inc · Dillingham, AKS/N 32-40869 N8986PNielsen James R · Carson City, NVS/N 24-4446 N8987CDouble M Charters LLC · Lakeland, FLBuilt 1976 · S/N 32R-7680148 N8988NCicero Flying Club LLC · Indianapolis, INBuilt 1969 · S/N 32-40871 N898CPThomas Robert M Jr · Kissimmee, FLBuilt 1975 · S/N 32-7640031 N898DSBeretta James P · Indian Springs, ALBuilt 1977 · S/N 32R-7780358 N8990PBaitanator Inc · Lamesa, TXBuilt 1966 · S/N 24-4451 N8991PCendejas Agustin · Chino, CABuilt 1966 · S/N 24-4452 N8992NBenedict Kevin M · Lakeland, FLBuilt 1970 · S/N 32-40875 N8992PL And L Aviation Inc · Mount Airy, MDBuilt 1966 · S/N 24-4453 N8993PPitcher Benjamin Alan · Fishers, INBuilt 1966 · S/N 24-4454 N8996NBickford Shawn A · Auburn, CABuilt 1969 · S/N 32-40879 N8997PF2 Management LLC · Canoga Park, CAS/N 24-4458 N8998NHangar Cc5 LLC · Gainesville, GABuilt 1969 · S/N 32-40881 N8998PMoore Jeffrey · Oceanside, CABuilt 1966 · S/N 24-4459 N8999PBednorski Craig A Trustee · Grass Valley, CABuilt 1966 · S/N 24-4376 N89BRN89br LLC · Wilmington, DEBuilt 1967 · S/N 27-3618 N89FMRadia LLC · Castro Valley, CAS/N 27-0268

Back to AD 84-19-03 R1