Skip to content

Registered aircraft · 614

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

N100PFPony Express Aviation LLC · Miami Beach, FLBuilt 2000 · S/N 525-0390 N100SBA-7 Austin Aviation LLC · Amarillo, TXBuilt 2011 · S/N 525C0061 N101USky West Aviation Inc Trustee · Albuquerque, NMBuilt 2001 · S/N 525-0454 N103CLBlue Lake Enterprises LLC · Incline Village, NVBuilt 2003 · S/N 525A0178 N103DSHr Leasing LLC · Dover, DEBuilt 2005 · S/N 525B0031 N104WFRedtail Management LLC · Ocilla, GABuilt 2002 · S/N 525A0122 N105ADComputer Service Professionals Inc DBA · Wilmington, DEBuilt 2010 · S/N 525C-0013 N106CJCitation 525 Inc · Eugene, ORBuilt 1993 · S/N 525-0006 N109APCj2 131 LLC · Milwaukee, WIBuilt 2002 · S/N 525A0131 N10PFAqua Lift LLC · Key Largo, FLBuilt 2003 · S/N 525A0165 N110PRCrown Air LLC · Bend, ORBuilt 2002 · S/N RB-29 N1127KHutter Charles G · Carson City, NVBuilt 1998 · S/N 525-0293 N112GSMldw Holdings LLC · Darien, CTBuilt 2002 · S/N 525A0127 N113BGWdc Equipment LLC · Webster, TXBuilt 2002 · S/N 525A0078 N11LGLima Golf Investments LLC · Bigfork, MTBuilt 1994 · S/N 525-0066 N121VMAlan Aviation LLC · Altadena, CAS/N 525-0314 N1220WP2 Flight Operations LLC · Fort Worth, TXBuilt 2003 · S/N 525A0146 N122KHAirric LLC · Miromar Lakes, FLBuilt 2003 · S/N 525A0159 N124BGAdvance Jets LLC · Cincinnati, OHBuilt 1999 · S/N 525-0345 N124HMiss Juliet LLC · Chatsworth, GABuilt 2002 · S/N 525A-0068 N125DGFugal Aviation LLC · Pleasant Grove, UTBuilt 2006 · S/N 525B0060 N126AFRigi Inc · Portsmouth, NHBuilt 2019 · S/N 126 N1277EHeaven Express LLC · Corralitos, CABuilt 2002 · S/N 525A0076 N127MJZacj LLC · Zanesville, OHBuilt 1998 · S/N 525-0266 N12GYValiair Limited Co Trustee · Casper, WYBuilt 2000 · S/N 525-0374 N131PLPd Aero LLC · Oronogo, MOBuilt 1994 · S/N 525-0057 N1327JAbsolute Altitude LLC · Bellefontaine, OHBuilt 1993 · S/N 525-0009 N133GLHs Air LLC · Little Rock, ARBuilt 1993 · S/N 525-0001 N137BGCroell Aviation LLC · New Hampton, IABuilt 2005 · S/N 525B0032 N140DARamsey Hill Aviation LLC · River Falls, WIBuilt 2003 · S/N 525A0140 N143QCKeystone Senior Ac LLC · North Miami, FLBuilt 2004 · S/N RB-114 N144ALB&K Leasing Company Inc · Big Bear Lake, CABuilt 2005 · S/N 525B0044 N144YDZellair LLC · Wilmington, DEBuilt 2003 · S/N 525A0144 N146MMJackdaw Inc Trustee · Wilmington, DEBuilt 1997 · S/N 5250226 N146SMTurbo Air Charter LLC · Boise, IDBuilt 2003 · S/N 525A0154 N148FBTelum Air LLC · Sioux Falls, SDBuilt 2003 · S/N 525A0148 N14CJJh Aircraft Management Inc · Anchorage, AKBuilt 2010 · S/N 525C0001 N152KVPlane House LLC · Indianapolis, INBuilt 1996 · S/N 525-0152 N153CJAbbey Air Inc · Birmingham, ALBuilt 2003 · S/N 525A0153 N155CGBigees Air LLC · Sioux Falls, SDBuilt 1997 · S/N 525-0214 N156MLAir Miles LLC · River Falls, WIBuilt 1996 · S/N 525-0156 N159JSB&L Adventures LLC · Sealy, TXBuilt 2005 · S/N 525B0038 N162ECCitation Dreams LLC · Inlet Beach, FLBuilt 2005 · S/N 525B0026 N163MData Center Services Leasing LLC · Salem, ORBuilt 2011 · S/N 525C0035 N167DPRgv Sky LLC · Harlingen, TXBuilt 2003 · S/N RB-67 N170MUCitationjet 525 LLC · Wilmington, DEBuilt 1996 · S/N 525-0170 N170TMJba LLC · Berkeley, CABuilt 2002 · S/N 525A0100 N177VVDodson International Parts Inc · Rantoul, KSBuilt 1997 · S/N 525-0182 N179WCBailburch Aviation LLC · Little Rock, ARBuilt 2005 · S/N 525B0025 N17LJGenetech Animal Reproduction LLC · Purcell, OKBuilt 2000 · S/N 525-0372

Back to AD 97-01-05