Skip to content

Registered aircraft · 20,683

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:90-06-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:90-06-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:90-06-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:90-06-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:90-06-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:90-06-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.

N570NDAerosim Academy Inc · Sanford, FLBuilt 2009 · S/N 172S10847 N570SPOne Seventy To Delta LLC · Scottsdale, AZBuilt 2000 · S/N 172S8495 N5710RMarshall Fred R · Tulsa, OKBuilt 1965 · S/N 17253367 N5710TLaney Charles A · Maiden, NCBuilt 1964 · S/N 17251610 N5711TColeman Darryl W · Fayetteville, GABuilt 1964 · S/N 17251611 N5712RGlobal Learning Solutions Inc · Montrose, COBuilt 1965 · S/N 17253370 N5712TSessoms Keith V · Seagrove, NCBuilt 1964 · S/N 17251612 N5713RAirspeed Marketing LLC · Phoenix, AZBuilt 1965 · S/N 17253372 N5713TSears Irwin C · Rockwall, TXBuilt 1964 · S/N 17251613 N5714AWeddle William H · Winston, NMS/N 28314 N5715ASkinner Norman D · Osceola, IABuilt 1956 · S/N 28315 N5715TCarter James · Thornville, OHBuilt 1964 · S/N 17251615 N5716ASaile Daniel K · Skiatook, OKBuilt 1956 · S/N 28316 N5716RUdenburg Scott M · Cotter, ARBuilt 1965 · S/N 17253378 N5718TMccormack Timothy J · Marcy, NYS/N 17251618 N5719APinson Danny L · Grand Junction, COS/N 28319 N5719RProfessional Aviation Aircraft Services Ltd · New Philadelphia, OHBuilt 1965 · S/N 17253383 N571BWBridgewater State University · Bridgewater, MABuilt 2004 · S/N 172S9738 N571CACivil Air Patrol · Maxwell Afb, ALBuilt 2024 · S/N 172S13251 N571JAJa Flight Services LLC · Sugar Grove, ILBuilt 2007 · S/N 172S10549 N571NDVertol Systems Co Inc · Destin, FLBuilt 2009 · S/N 172S10853 N571SPChristiansen Aviation LLC · Wilmington, DEBuilt 2000 · S/N 172S8496 N5720EInstall Pro Construction LLC · Henderson, NVBuilt 1978 · S/N 17271926 N5720TFrost Nathan L · Olympia, WABuilt 1964 · S/N 17251620 N5721TSeattle Seaplanes LLC · Seattle, WABuilt 1964 · S/N 17251621 N5722RCalhoun Barry R · Richardson, TXBuilt 1965 · S/N 17253387 N5723AAdamson Steven C · Jonesboro, GAS/N 28323 N5723RCoffey Bryan K · Anchorage, AKBuilt 1965 · S/N 17253389 N5723TColeman David R · Limerick, MEBuilt 1964 · S/N 17251623 N5724JPurdue Aviation LLC · West Lafayette, INBuilt 1980 · S/N 17273827 N5724RMartindale Bryan T · Springfield, ILBuilt 1965 · S/N 17253393 N5726THall Edward M · Brainerd, MNBuilt 1964 · S/N 17251626 N5727EZeitvogel Jeanine · Gulf Shores, ALBuilt 1978 · S/N 17271928 N5727RBiederman Scott · Pompano Beach, FLS/N 17253396 N5728AMcgiffen Christine L · Vincennes, INBuilt 1956 · S/N 28328 N5729AThomas Scott S · Wytheville, VABuilt 1956 · S/N 28329 N5729RMarreno Eddie J · Green Cove Springs, FLS/N 17253398 N5729TConservair Inc · Montgomery, TXBuilt 1964 · S/N 17251629 N572BWBridgewater State University · Bridgewater, MABuilt 2003 · S/N 172S9426 N572JAJ.A. Flight Services LLC · Sugar Grove, ILBuilt 2007 · S/N 172S10553 N572NDAerosim Academy Inc · Sanford, FLBuilt 2009 · S/N 172S10940 N572RJUniversity Of Michigan Flyers Inc · Ann Arbor, MIBuilt 1973 · S/N 17261600 N572SPOld Friend Air LLC · Junction City, ORBuilt 2000 · S/N 172S8498 N5730AMunson Steven L · Martinsburg, WVBuilt 1956 · S/N 28330 N5730JLindley Field Flying School LLC · Greensboro, NCBuilt 1980 · S/N 17273828 N5731RGoward Steven Lee · Oakley, MIBuilt 1965 · S/N 17253400 N5731TUhen Instruments Inc · Burlington, WIS/N 17251631 N5732EWynn Josh · Bucyrus, OHBuilt 1978 · S/N 17271929 N5733RWarren Jeffrey · Omaha, NEBuilt 1965 · S/N 17253402 N5733TCountry Flyin Inc · Homestead, FLBuilt 1964 · S/N 17251633

Back to AD 90-06-03 R1