Skip to content

Registered aircraft · 20,481

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.

N8953GAirfleet Solutions LLC · Newark, DEBuilt 1970 · S/N 18260493 N8953XHenning Jeffrey Carl · Prescott, AZBuilt 1961 · S/N 18253353 N8954XGansz Kenneth L · Clare, IABuilt 1961 · S/N 18253354 N8955XPampa Office Supply · Elk City, OKBuilt 1961 · S/N 18253355 N8956TBrown Donald L · Peoria, AZS/N 52856 N8956XLove Brandon · Big Sandy, TXS/N 18253356 N895AHAerospace Asset Holdings LLC · Wilmington, DEBuilt 1981 · S/N U20606419 N895UPFlying Frog Aviation LLC · Stillwater, MNBuilt 1961 · S/N 18253351 N8962XWb Aero LLC · Mountain Home, TXS/N 18253362 N8963GThompson Cory D · Holly, COBuilt 1970 · S/N 18260503 N8963XZimmermann Lukas · Tucson, AZBuilt 1961 · S/N 18253363 N8964GSandige David J · Mckinleyville, CABuilt 1970 · S/N 18260504 N8965TRoberts Coleen M · Roseburg, ORBuilt 1960 · S/N 52865 N8966GBerti Robert C · Diamond Springs, CABuilt 1970 · S/N 18260506 N8966XHotrod 182 LLC · Rayville, LABuilt 1961 · S/N 18253366 N8967GHill Cannon E · West Richland, WAFirst renewal noticeS/N 18260507 N8969GGaluska Matthew · Minnetonka, MNBuilt 1970 · S/N 18260509 N896AHAerospace Asset Holdings LLC · Wilmington, DEBuilt 1981 · S/N 20700732 N896CPCivil Air Patrol · Maxwell Afb, ALS/N 18282394 N896SASwitlik Aviation Maintenance Inc · Fort Myers, FLBuilt 1970 · S/N 21059358 N8970TLamle Eric W · Okeene, OKBuilt 1960 · S/N 52870 N8972GDay & Night Plumbing & Heating LLC · Sidney, NEBuilt 1970 · S/N 18260512 N8972XFoothills Aviation LLC · Buhl, IDBuilt 1961 · S/N 18253372 N8973GGough John C · Gooding, IDFirst renewal noticeBuilt 1970 · S/N 18260513 N8974GPike Vincent I · Bagdad, AZBuilt 1970 · S/N 18260514 N8974XHarris Warren R · Mccleary, WABuilt 1960 · S/N 18253374 N8976GTeeray LLC · Mountain City, TNBuilt 1970 · S/N 18260516 N8976TKumm John J · Clarkston, WABuilt 1960 · S/N 52876 N8977TAllsup Delmar D III · Oakhurst, CABuilt 1960 · S/N 52877 N8979TNardi Patty K · Missoula, MTFirst renewal noticeBuilt 1960 · S/N 52879 N897AHAerospace Asset Holdings LLC · Wilmington, DES/N 21064163 N897CPCivil Air Patrol · Maxwell Afb, ALBuilt 2015 · S/N 18282395 N897SMDomich Jeffrey E · Petaluma, CABuilt 2011 · S/N 18282309 N8980TN8980t LLC · Dallas, TXS/N 52880 N8981TCharlie Tango LLC · Rapid City, SDBuilt 1960 · S/N 52881 N8981XBales Philip J · Chandler, AZBuilt 1961 · S/N 18253381 N8982TLarson Lynn R · Casselton, NDBuilt 1960 · S/N 52882 N8984XSkydive Florida Keys Inc · Summerland Key, FLBuilt 1961 · S/N 18253384 N8985TDonald V Johns Jr · Rush, COS/N 52885 N8985XHill Jack · New Lenox, ILS/N 18253385 N8987TPeavy Magnus Delacy IV · Crawfordville, FLBuilt 1960 · S/N 52887 N898AHAerospace Asset Holdings LLC · Wilmington, DES/N 207-00123 N898BPetropulos James J · Juneau, AKBuilt 1973 · S/N 18262080 N898BHPompa Oliver · Tuscon, AZBuilt 1980 · S/N 21064108 N898SWHealy Ronald L · Anchorage, AKBuilt 1955 · S/N 32112 N898TMKingsley Kaland W · Miller, MOBuilt 1957 · S/N 34406 N8990TPoulter Michael D · San Angelo, TXBuilt 1960 · S/N 52890 N8992GKing William · Tallulah, LABuilt 1970 · S/N 18260532 N8993TCoughran Aviation LLC · Rio Vista, CABuilt 1960 · S/N 52893 N8993XEvans David J · Parker, COBuilt 1961 · S/N 18253393

Back to AD 84-10-01 R1