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.

N5816RLittle Bird Airways LLC · Hamburg, NYBuilt 1965 · S/N 17253485 N5818RVanthof Douglas D · Sioux Falls, SDBuilt 1965 · S/N 17253487 N581CGLoveless Jacob L · Carlinville, ILBuilt 1966 · S/N 17255581 N581ESQuinby Alan D · Woodward, OKBuilt 1978 · S/N 17271811 N5820ARivas Tito David · San Diego, CABuilt 1956 · S/N 28420 N5821ABaraga Matthew J · Texarkana, TXBuilt 1956 · S/N 28421 N5822ASteen Valerie · Lufkin, TXS/N 28422 N5825AHayes William A · Falls Of Rough, KYS/N 28425 N5828APerera Carl Anthony · Gilbert, AZBuilt 1956 · S/N 28428 N5829AVine Clayton A · Wolf Point, MTS/N 28429 N582LPCape Island Aviation LLC · Millville, NJBuilt 2004 · S/N 172S9582 N582SPSvanberg Craig Emile · Dayt Bch Sh, FLBuilt 2000 · S/N 172S8509 N5830AChapman Erin A · Edmond, OKBuilt 1956 · S/N 28430 N5832ABurgess Kelly M · Dannebrog, NEBuilt 1956 · S/N 28432 N5832JAerial Advertising Services · Livermore, CAS/N 17273842 N5833AJones Curtis DBA · Jacksonville, NCBuilt 1956 · S/N 28433 N5833JAlbatross Air Inc · Beaver, WVBuilt 1980 · S/N 17273843 N5835ABoyd Edward L · Riverton, ILBuilt 1956 · S/N 28435 N5836AMallach Kenneth L · Gatesville, TXFirst renewal noticeBuilt 1956 · S/N 28436 N5837ACrawford Mike R · Flowery Branch, GABuilt 1956 · S/N 28437 N5841ASeipel Damian Y · Huntington Beach, CABuilt 1956 · S/N 28441 N5841GCrawford Trevor Nicolas · Potter Valley, CABuilt 1956 · S/N 28499 N5846AHalford Richard W · Eagle River, AKBuilt 1956 · S/N 28446 N5847ACochran Josh · New Orleans, LABuilt 1956 · S/N 28447 N5849AAllison Michael L · Lubbock, TXBuilt 1956 · S/N 28449 N584SFDsr Cherokee 180 LLC · Dallas, TXBuilt 1968 · S/N 17256834 N584SPTexas State Technical College At Waco · Waco, TXBuilt 2000 · S/N 172S8511 N5851RSmoky Bear Air LLC · Rockwood, TNBuilt 1965 · S/N 17253520 N5852RBenien Dennis A · Napoleon, OHBuilt 1965 · S/N 17253521 N5853ADanz Frederick C · Mattawa, WABuilt 1956 · S/N 28453 N5853RHall Gary M · Muncie, INBuilt 1965 · S/N 17253522 N5855RDonelan Matt B · Springfield, ILBuilt 1965 · S/N 17253524 N5857ABrandt Jeff D · Ankeny, IABuilt 1956 · S/N 28457 N5857RWaypoint Equipment LLC · Mckinney, TXBuilt 1966 · S/N 17253526 N5858AMadey Benjamin · Ghent, NYBuilt 1956 · S/N 28458 N5858RNitz Terry L · Fredericksburg, VABuilt 1965 · S/N 17253527 N585RDBravo Aircraft LLC · Alpharetta, GABuilt 2021 · S/N 172S12687 N5860AMrd Aero LLC · Manheim, PAS/N 28460 N5860RSkyhawk Ventures LLC · Boise, IDBuilt 1965 · S/N 17253529 N5862ASanders Mark R · Towner, COBuilt 1956 · S/N 28462 N5862RMcgowan Keegan M · San Antonio, TXBuilt 1965 · S/N 17253531 N5863ADabney Richard W · Tanner, ALBuilt 1956 · S/N 28463 N5864AS Aviation LLC · Wisconsin Dells, WIBuilt 1956 · S/N 28464 N5864RBattle Proven Leadership LLC · Crown Point, INBuilt 1965 · S/N 17253533 N5866AChipman Jeffrey M · Rising Sun, INS/N 28466 N5866RNeal Edward K · Laud By Sea, FLS/N 17253535 N5867AUrciuoli Salvatore · Holbrook, NYBuilt 1956 · S/N 28467 N5867RGoatley John E · Springfield, KYS/N 17253536 N5868RRizzo John M Sr · Sugar Land, TXBuilt 1965 · S/N 17253537 N5869AHurt Wally · Amboy, WABuilt 1956 · S/N 28469

Back to AD 90-06-03 R1