Skip to content

Registered aircraft · 54,015

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-20-03-R2') 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-20-03-R2') 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-20-03-R2')
    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-20-03-R2')
  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-20-03-R2')
  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-20-03-R2')
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.

N8044ZLever Samuel C · Udall, KSS/N 15071255 N8045Mcclure Richard A · Edna, TXS/N 18262046 N80454Tadao LLC · Tucson, AZBuilt 1976 · S/N 17266593 N80456Barash Geva S · Ashland, MABuilt 1976 · S/N 17266595 N80458Kolpack Glenn H · Sonora, CABuilt 1976 · S/N 17266597 N8045ASalter James M · Crested Butte, COBuilt 1952 · S/N 20897 N8045LAmonett Rodney · Abilene, TXBuilt 1967 · S/N 17256245 N8045QEcho Bay Corporation · Bow, WABuilt 1978 · S/N 18503632 N8045VGreater Houston Soaring Assoc · Needville, TXBuilt 1967 · S/N 188-0295 N80469Hetherly Bryce D · Clintondale, NYS/N 17266603 N8046BAnderson Charles D · Fairbanks, AKBuilt 1957 · S/N 29846 N8046SHolmes Gerald P · Billerica, MABuilt 1965 · S/N 15061646 N8046VSt Bernard Parish Police Jury · Chalmette, LABuilt 1967 · S/N 188-0296 N8046ZBest Auto Sales LLC · Plummer, IDS/N U206-0446 N80470Coddiwomple LLC · Newberg, ORBuilt 1976 · S/N 17266604 N80471Dairy Air Inc · Wyoming, PABuilt 1976 · S/N 17266605 N80472Simons George Trustee · Bouse, AZBuilt 1976 · S/N 17266606 N80475Texas Southern University · Houston, TXS/N 17266608 N80476Sky Roamers LLC · Columbus, NEBuilt 1976 · S/N 17266609 N8047BGuidry Janice C · Mechanicsville, VABuilt 1957 · S/N 29847 N8047ECivil Air Patrol Inc · Maxwell Afb, ALBuilt 1984 · S/N 18268385 N8047FPoole Terrell W · Rigby, IDBuilt 1966 · S/N 15064147 N8047XFitzgerald Jeff D · Smithfield, UTBuilt 1961 · S/N 17248547 N8047ZBooth James L · Bozeman, MTS/N 180-52312 N80483Harrell Matthew J · Grand Haven, MIBuilt 1976 · S/N 17266611 N80484Mor Aviation 172m LLC · Gaithersburg, MDBuilt 1976 · S/N 17266612 N80486Romoser Carey E · Simpsonville, SCBuilt 1976 · S/N 17266613 N80487Williams Fredrick Glen · Auburn, ALS/N 17266614 N80489P & K Aviation LLC · Neshkoro, WIBuilt 1976 · S/N 17266615 N8048AWilson Earl William · Rockford, ILBuilt 1952 · S/N 20900 N8048BHohman Brent A · Larchwood, IAS/N 29848 N8048FParris Morgan Aaron R · Taylors, SCBuilt 1966 · S/N 15064148 N8048LFour Dudes And A Plane LLC · Whitehouse, OHS/N 17256248 N8048MWilson Curtis E · Townsend, GABuilt 1976 · S/N 18264532 N8048ZWalker John A · Kotzebue, AKS/N U206-0448 N80490American Patrols Inc · Midland, TXS/N 17266616 N80491Duffys Aircraft Sales & Leasing Inc · Neillsville, WIBuilt 1976 · S/N 17266617 N80495Space Coast Aero LLC · Melbourne, FLBuilt 1976 · S/N 17266619 N80496Bickel Gregory A · Mckinleyville, CABuilt 1976 · S/N 17266620 N80497Ducksrus LLC · Indianapolis, INBuilt 1976 · S/N 17266621 N80499Srf · Waterloo, IABuilt 1976 · S/N 18503123 N8049GStone & Phillips Aviation LLC · Youngstown, FLBuilt 1971 · S/N 177RG0049 N8049LPrewitt Murray L · Lake Jackson, TXS/N 17256249 N8049STri State Aero Inc · Martinsburg, WVBuilt 1965 · S/N 15061649 N8049TJasper Ann L · Las Vegas, NVS/N 56749 N804BD G Leasing LLC · Houston, TXBuilt 1976 · S/N 17266584 N804BLFlores Omar Javier · New Braunfels, TXBuilt 1979 · S/N 17273041 N804CAAshley Nostalgia · Midlothian, TXBuilt 1974 · S/N 18262942 N804PMSmp Outdoors Inc · Joseph, ORBuilt 1962 · S/N 18254108 N80507High Flight Academy LLC · Allison Park, PABuilt 1976 · S/N 17266626

Back to AD 87-20-03 R2