Skip to content

Registered aircraft · 1,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:82-09-51-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:82-09-51-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:82-09-51-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:82-09-51-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:82-09-51-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:82-09-51-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.

N8532GAm Pm Services LLC- Blue Sky Series · Northbrook, ILBuilt 2001 · S/N 7532 N8533DAm Pm Services Llcblue Sky Series · Northbrook, ILBuilt 2001 · S/N 7533 N8541DAm Pm Services LLC - Blue Sky Series · Northbrook, ILBuilt 2001 · S/N 7541 N854ASSkywest Airlines Inc · St. George, UTBuilt 2000 · S/N 7382 N8554AAm Pm Services LLC - Blue Sky Series · Northbrook, ILBuilt 2001 · S/N 7554 N855MMMarklyn Jet Parts LLC · Dallas, TXBuilt 1990 · S/N 5064 N8560FAm Pm Services LLC - Blue Skies Series · Northbrook, ILBuilt 2001 · S/N 7560 N856ASSkywest Airlines Inc · St George, UTBuilt 2000 · S/N 7404 N856JLZjets Aviation LLC · Richmond, TXBuilt 1991 · S/N 5094 N856PPWkair4 LLC · Boerne, TXBuilt 2001 · S/N 5483 N8577DAm Pm Services LLC · Northbrook, ILBuilt 2001 · S/N 7577 N8580AAm Pm Services LLC - Alpha Series · Northbrook, ILBuilt 2001 · S/N 7580 N8587EAm Pm Services LLC - Alpha Series · Northbrook, ILBuilt 2001 · S/N 7587 N8588DAm Pm Services LLC - Alpha Serie · Northbrook, ILBuilt 2001 · S/N 7588 N858CV28039 LLC · North Olmsted, OHBuilt 2008 · S/N 5772 N8598BAm Pm Services LLC · Northbrook, ILBuilt 2001 · S/N 7598 N859AGRed Line Air LLC · Danbury, CTBuilt 2010 · S/N 5831 N8604CAm Pm Services LLC Foxtrot Series · Northbrook, ILBuilt 2002 · S/N 7604 N860JJ860jj LLC · Brookfield Townshi, OHBuilt 2001 · S/N 7471 N8611AAm Pm Services LLC Foxtrot Series · Northbrook, ILBuilt 2002 · S/N 7611 N8623AAm Pm Services LLC - Foxtrot Series · Northbrook, ILBuilt 2002 · S/N 7623 N8631EAm Pm Services LLC - Foxtrot Series · Northbrook, ILBuilt 2002 · S/N 7631 N8646AAm Pm Services LLC - Foxtrot Series · Northbrook, ILBuilt 2002 · S/N 7646 N8659BAm Pm Services LLC - Departure Series · Northbrook, ILBuilt 2002 · S/N 7659 N8665AAm Pm Services LLC - Departure Series · Northbrook, ILBuilt 2002 · S/N 7665 N8672AAm Pm Services LLC Departure Series · Northbrook, ILBuilt 2002 · S/N 7672 N8674ATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2002 · S/N 7674 N8683BSlate Crj Acquisitions 1 LLC · Johnstown, PABuilt 2002 · S/N 7683 N8688CGold Coast Aviation · Fort Lauderdale, FLBuilt 2002 · S/N 7688 N868RBSav Aviation LLC · Jacksonville, TXBuilt 1993 · S/N 5128 N8694ASlate Crj Acquisitions 1 LLC · Johnstown, PABuilt 2002 · S/N 7694 N8696CTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2002 · S/N 7696 N8698ATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2002 · S/N 7698 N86NPIcpf LLC · Solon, OHBuilt 2011 · S/N 5874 N8709ATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2002 · S/N 7709 N8710ATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2002 · S/N 7710 N8718ETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2002 · S/N 7718 N871ASFrontera Flight Holdings Inc · Dover, DEBuilt 2001 · S/N 7537 N872BCBcc Aviation LLC · Dover, DEBuilt 2000 · S/N 5479 N873ASSkywest Airlines Inc · St George, UTBuilt 2001 · S/N 7549 N8747BTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2003 · S/N 7747 N874ASCorporate Flight Management Inc DBA · Smyrna, TNBuilt 2001 · S/N 7551 N8751DTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2003 · S/N 7751 N8758DTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2003 · S/N 7758 N875ASCorporate Flight Management Inc DBA · Smyrna, TNBuilt 2001 · S/N 7559 N876ASSkywest Airlines Inc · St George, UTBuilt 2001 · S/N 7576 N8771ATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2003 · S/N 7771 N877ASSkywest Airlines Inc · St George, UTBuilt 2001 · S/N 7579 N877HChallenger 5445 LLC · Allentown, PABuilt 2000 · S/N 5445 N8783ESlate Crj Acquisitions I LLC · Johnstown, PABuilt 2003 · S/N 7783

Back to AD 82-09-51 R1