Skip to content

Registered aircraft · 20,483

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

N370CPCivil Air Patrol · Maxwell Afb, ALBuilt 2007 · S/N 18282000 N370JCSouth Oaks Inc · Hollywood, FLBuilt 1977 · S/N U206-04024 N370JHNational Aircraft Leasing Corp · Greenville, DEBuilt 2009 · S/N 18282191 N370MEFlying Circuss Aviation Services Inc · Wasilla, AKBuilt 2000 · S/N 20608126 N370RAmerican Aircraft Management LLC · Irving, TXBuilt 1980 · S/N U20605501 N3710DHiller Paul D · Grafton, OHBuilt 1957 · S/N 34410 N3710UFollette Aviation LLC · Scottsdale, AZBuilt 1963 · S/N 18255110 N3712UVarian Dennis D · West Lafayette, OHBuilt 1963 · S/N 18255112 N3712YRpx Technologies Inc · Stillwater, OKBuilt 1963 · S/N 21058212 N3713DHedgecock David H · Elkhorn, WIFirst renewal noticeBuilt 1957 · S/N 34413 N3713UDaggy Curt L III · Red Bluff, CABuilt 1963 · S/N 18255113 N3714DZombo Brian T · Youngsville, NYBuilt 1957 · S/N 34414 N3714USchaffer John Paul · Prior Lake, MNBuilt 1963 · S/N 18255114 N3714YReichelt Mark C · Big Sandy, MTBuilt 1963 · S/N 21058214 N3715JSmoot Nathan · Fairbanks, AKS/N 18255115 N3716UPlane Fun Inc Tr Trustee · Snellville, GABuilt 1963 · S/N 18255116 N3717YOwosso Navigators Club LLC · Owosso, MIBuilt 1963 · S/N 21058217 N3719DVector Stunts Inc · Bend, ORBuilt 1957 · S/N 34419 N3719UOlsen Marvin J · Kent, WABuilt 1963 · S/N 18255119 N3719YG & G Famrs Of Gilbert Inc · Gilbert, LAS/N 21058219 N371CPCivil Air Patrol · Maxwell Afb, ALBuilt 2007 · S/N 18282001 N3720DHarrington Patrick M · Quitman, MSBuilt 1957 · S/N 34420 N3721UDanko Lawrence G Trustee · Paden, OKBuilt 1963 · S/N 18255121 N3722DSkydive Inc · Eagle Creek, ORBuilt 1957 · S/N 34422 N3722UDudash George M · Escondido, CABuilt 1963 · S/N 18255122 N3723DOlsen'S Grain Inc · Chino Valley, AZBuilt 1957 · S/N 34423 N3724URouter Bit Service Co Inc · High Point, NCBuilt 1963 · S/N 18255124 N3725DMulhaney James T · Wasilla, AKS/N 34425 N3726CRogers Glenn A Jr · Sedona, AZBuilt 1978 · S/N R18200321 N3727DTwo Seven Delta LLC · Meridian, IDBuilt 1957 · S/N 34427 N3728DRoberts Anthony E · Millville, CABuilt 1957 · S/N 34428 N3728UMaupin Daniel D · Corvallis, ORBuilt 1963 · S/N 18255128 N3728YPrt Aviation Corp · Wilmington, DEBuilt 1963 · S/N 21058228 N372AFFlyslow Aviation LLC · Sterling, VABuilt 2003 · S/N 18281191 N372CPCivil Air Patrol · Maxwell Afb, ALBuilt 2007 · S/N 18282002 N372MEAircraft Partner Holdings Inc Trustee · BerlinBuilt 2000 · S/N 20608130 N372SFBrophy Martin Joseph · Fort Collins, COBuilt 1978 · S/N 18266569 N372VUPerry Robert P · Chelan, WABuilt 1955 · S/N 31428 N3730DLedbetter Jeffrey Allen · Huntley, ILS/N 34430 N3730UWarren Kevin · Berger, MOBuilt 1963 · S/N 18255130 N3731YHaglin Dana · Erie, COBuilt 1963 · S/N 21058231 N3732DClark William M · Ann Arbor, MIBuilt 1957 · S/N 34432 N3732UGifford Tracy G · Stephenville, TXBuilt 1963 · S/N 18255132 N3733YHolliday Ivan Scott · Poplarville, MSBuilt 1963 · S/N 21058233 N3734DVessey William M · Yuma, AZBuilt 1957 · S/N 34434 N3736UDelong Don R · Wheeler, MIBuilt 1963 · S/N 18255136 N3738DHall Chris S · Garden City, MOBuilt 1959 · S/N 34438 N3738YAirborne Solutions Group LLC · Dayton, OHBuilt 1963 · S/N 21058238 N3739DBodie Aviation Ltd · Laporte, COS/N 34439 N3739UYown Inc · Ethridge, MTBuilt 1963 · S/N 18255139

Back to AD 84-10-01 R1