Registered aircraft · 2,873

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

N1002GFlying Fox Aviation LLC · Idaho Falls, IDBuilt 2000 · S/N 27-0295 N10031Taylor Douglas Scott · Fairfield, CABuilt 2000 · S/N 29-0240 N1003LGill David P · Seabrook, TXBuilt 2001 · S/N 29-0272 N10045Southern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2002 · S/N 29-0281 N10048Kumin Phillip R · Los Gatos, CABuilt 2002 · S/N 29-0282 N1004QChaudhary Rizvon · Louisville, KYBuilt 2000 · S/N 29-0241 N1004SRosenfeld Ronald S Trustee · Perry, MEBuilt 2003 · S/N 29-0289 N1005XSigler Lanny · Albuquerque, NMBuilt 2000 · S/N 27-0302 N1006APressley Brent DBA · Morristown, TNBuilt 2002 · S/N 29-0284 N10079Wier Michael D · Pompano Beach, FLBuilt 2002 · S/N 30-0063 N1009MPrecision Wings LLC · Saint Augustine, FLBuilt 2002 · S/N 29-0287 N100DXRegistered aircraftBuilt 1996 · S/N 29-0100 N100KSIndependent Aviation Consultants LLC · Sparks, GABuilt 2001 · S/N 29-0262 N1011RRegistered aircraftBuilt 2000 · S/N 29-0248 N1012PFly Slc LLC · Salt Lake City, UTBuilt 2000 · S/N 29-0249 N1013LSouthwest Medical Associates Inc · Rockport, TXBuilt 2004 · S/N 29-0327 N1016BWatts Daniel S · Seal Beach, CABuilt 2000 · S/N 29-0251 N1016CMartinek Leasing LLC · Bellbrook, OHBuilt 2003 · S/N 29-0297 N1016EHiggins Chris · Sammamish, WABuilt 2000 · S/N 29-0230 N1016XRadial Holdings LLC · Fort Worth, TXBuilt 2000 · S/N 27-0292 N1017CCao Gadgets LLC · Irvine, CABuilt 2001 · S/N 29-0274 N1018VHack Mark A · Floyds Knobs, INBuilt 2005 · S/N 29-0350 N1019CHunter James A · Elizabeth City, NCBuilt 2001 · S/N 29-0271 N1019ZJb Air LLC · Lindsay, OKBuilt 2004 · S/N 290324 N101DXPatierno David M · Templeton, CABuilt 2000 · S/N 29-0221 N101TLojek Donald W · Boise, IDBuilt 1964 · S/N 2887 N1020AIrving Donald J · Deland, FLBuilt 2003 · S/N 29-0316 N1021URegistered aircraftBuilt 2004 · S/N 29-0325 N1022UCivil Precast Corp · Ridgeland, MSBuilt 2007 · S/N 31-0066 N1026ASouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2004 · S/N 290321 N1026CMooney Howard James Jr · Lake Wales, FLBuilt 1995 · S/N 27-0203 N1026FDeramus Eugene T · Garden Ridge, TXBuilt 2004 · S/N 29-0326 N1027TEye Candy Aircraft LLC · Jacksonville, FLBuilt 2003 · S/N 290307 N1029MHarris Charles T Trustee · Thousand Oaks, CAS/N 29-0315 N102PTNion LLC · New Century, KSBuilt 2008 · S/N 29-0511 N102TNTailwinds And Blue Skies LLC · Wilmington, DEBuilt 2008 · S/N 31-0102 N1030RThomas Leasing Enterprise LLC · Troy, MIBuilt 2001 · S/N 29-0278 N1032XSunrise Aviation Inc Trustee · Wilmington, DEBuilt 2007 · S/N 31-0074 N1032ZHoffman Curtis A · Marlborough, MABuilt 2003 · S/N 290309 N1033QKuhn Marcus J · Madison, WIBuilt 2003 · S/N 29-0310 N1034SSchlueter Jeffrey · Fernandina Beach, FLBuilt 2006 · S/N 29-0456 N1035NHiggins Michael S · Palatine, ILBuilt 2003 · S/N 29-0305 N10368S-A Clark Aviation LLC · Fort Smith, ARBuilt 2002 · S/N 29-0286 N1036RYork Aviation LLC · Asheboro, NCBuilt 2003 · S/N 29-0302 N1039SJohnson Robert E Jr · Southport, NCBuilt 2003 · S/N 29-0318 N103DXThornton Aaron Dewayne · Lubbock, TXBuilt 2008 · S/N 31-0100 N103TNArthur Lee E · Spring, TXBuilt 2008 · S/N 31-0103 N1041CHelzer Timothy · Tucson, AZBuilt 2003 · S/N 270321 N10422Jackson Benjamin Tillman · Rancho Mirage, CABuilt 2004 · S/N 29-0323 N1043HValiair Limited Co Trustee · Casper, WYBuilt 2007 · S/N 31-0058

Back to AD 2014-15-18