Skip to content

Registered aircraft · 101

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:2012-22-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-22-13') 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:2012-22-13')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-22-13')
  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:2012-22-13')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-22-13')
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.

N754LArrow Aviation Co LLC · Broussard, LAS/N 760754 N759PPhi Health LLC · Tempe, AZBuilt 2007 · S/N 760690 N760BGBristow U S LLC · New Iberia, LAS/N 760733 N764AMNorth Flight Aero Med · Grand Rapids, MIBuilt 2009 · S/N 760764 N768AMSpectrum Health Hospitals · Grand Rapids, MIBuilt 2009 · S/N 760710 N769PPhi Aviation LLC · Lafayette, LABuilt 2007 · S/N 760671 N76FXFlexjet Vertical Lift LLC · Stratford, CTBuilt 2005 · S/N 760585 N76GATurbine Holdings II LLC · New York, NYBuilt 1999 · S/N 760498 N76HHHallecopter LLC · Wilmington, DEBuilt 2010 · S/N 760807 N76PCSo Much For Subtlety LLC · Dover, DEBuilt 2005 · S/N 760597 N76ZAN76za LLC · New York, NYBuilt 2007 · S/N 760653 N772PPhi Aviation LLC · Lafayette, LABuilt 2008 · S/N 760730 N773BGBristow LLC · Lake Charles, LABuilt 2009 · S/N 760773 N781PPhi Health LLC · Tempe, AZBuilt 2006 · S/N 760630 N781RLGm Leasing Company LLC · Broussard, LABuilt 2007 · S/N 760673 N782RLGm Leasing Company LLC · Broussard, LABuilt 2007 · S/N 760666 N783RLGm Leasing Company LLC · Broussard, LABuilt 2008 · S/N 760735 N784RLGm Leasing Company LLC · Broussard, LABuilt 2008 · S/N 760721 N785PSale Reported · Robert, LASale reported, canceledBuilt 2006 · S/N 760635 N785RLGm Leasing Company LLC · Broussard, LABuilt 2006 · S/N 760639 N786RLGm Leasing Company LLC · Broussard, LABuilt 2006 · S/N 760618 N787RLGm Leasing Company LLC · Broussard, LABuilt 2009 · S/N 760778 N794PPhi Aviation LLC · Lafayette, LABuilt 2008 · S/N 760737 N797PPhi Health LLC · Tempe, AZBuilt 2008 · S/N 760742 N803SPma 1 LLC · Wilmington, DEBuilt 2001 · S/N 760520 N821SSFly Safe LLC · Wilmington, DEBuilt 2006 · S/N 760620 N8455Arrow Aviation Company LLC · Broussard, LAS/N 760407 N849PBArrow Aviation Co LLC · Broussard, LAS/N 760652 N861ALArrow Aviation Company LLC · Broussard, LABuilt 2002 · S/N 760529 N865ALArrow Aviation Company LLC · Broussard, LABuilt 2004 · S/N 760564 N866ALMar Aviation LLC · Tulsa, OKBuilt 2004 · S/N 760562 N868ALArrow Aviation Company LLC · Broussard, LABuilt 2004 · S/N 760580 N883ALBristow US LLC · New Iberia, LABuilt 2007 · S/N 760677 N891BGGm Leasing Co LLC · Broussard, LABuilt 2007 · S/N 760679 N893BGBristow U S LLC · New Iberia, LABuilt 2009 · S/N 760804 N896BGBristow U.S. LLC · New Iberia, LAS/N 760777 N905RDBristow LLC · Lake Charles, LABuilt 2006 · S/N 760610 N911BBBollinger Enterprises LLC · New Orleans, LABuilt 1998 · S/N 760485 N913GRS-76 Parts LLC · Blauvelt, NYS/N 760563 N913PBHealth Care District Of Palm Beach County · West Palm Beach, FLBuilt 1999 · S/N 760503 N914GRS-76 Parts LLC · Blauvelt, NYS/N 760556 N91AEPerfect Agreements Leasing Inc · Trabuco Canyon, CABuilt 2003 · S/N 760552 N926CFMontgomery Capital II Of Delaware LLC · Fort Washington, PABuilt 2004 · S/N 760567 N927MSOnyx Aviation LLC · Needham, MABuilt 2005 · S/N 760605 N9483Arrow Aviation Company LLC · Broussard, LAS/N 760510 N969YCYonkers Contracting Company Inc · Yonkers, NYBuilt 2005 · S/N 760583 N96SPGeneral Industries LLC · Camden, NJBuilt 2004 · S/N 760566 N981TSSale Reported · Milton, VTSale reported, pending cancellationBuilt 2002 · S/N 760524 N982TSIslander Holdings Ltd · Fort Lauderdale, FLBuilt 2002 · S/N 760523 N983TSIslander Holdings Ltd · Fort Lauderdale, FLBuilt 2001 · S/N 760518

Back to AD 2012-22-13