Skip to content

Registered aircraft · 20,681

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.

N12KBWings Over Texas Holdings LLC · Denton, TXBuilt 1973 · S/N 17261915 N12MJCruiseair Aviation Inc · Ramona, CABuilt 1972 · S/N 17261299 N12TYSewell Roger C · Meridian, IDBuilt 1960 · S/N 17248030 N13004Regnier Ryan A · Lockport, ILBuilt 1973 · S/N 17262439 N13008Midnite Sun Flying Club LLC · Eagle River, AKBuilt 1974 · S/N 17262441 N13009Laffey Joseph C · Saint Louis, MOBuilt 1973 · S/N 17262442 N1300TVarnado Calvin M · Palmer, AKBuilt 1965 · S/N 17253731 N1300YMammucari Leonard E · West Chester, PAS/N 17249000 N13020Hydeman Aviation Holdings LLC · Sacramento, CABuilt 1973 · S/N 17262449 N1302UTraining Planes LLC · Tampa, FLBuilt 1976 · S/N 17266994 N1302YDorning Patrick J · Ft Lauderdale, FLBuilt 1961 · S/N 17249002 N13033Iowa Lakes Community College · Estherville, IABuilt 1973 · S/N 17262453 N13036Hill Shane A · Kalispell, MTS/N 17262455 N13039Cendejas Agustin · Chino, CABuilt 1973 · S/N 17262456 N1303UGoodrich Pilot Center LLC · Johnson City, NYBuilt 1976 · S/N 17266995 N1303YDay Patrick J · Bloomer, WIS/N 17249003 N1304FRoach Galen D · Saint John, KSBuilt 1979 · S/N 17272993 N1304UGiving Wings Aviation LLC · Traverse City, MIBuilt 1976 · S/N 17266996 N1304YLyon Samantha J · Milton, FLS/N 17249004 N13053Skywatch Traffic Inc · Clearwater, FLBuilt 1973 · S/N 17262460 N13056Wings Over Texas Holdings LLC · Denton, TXBuilt 1973 · S/N 17262463 N13058Bouchard Ron R · Lambert, MTBuilt 1973 · S/N 17262465 N13059Zev Aviation LLC · Morristown, NJBuilt 1973 · S/N 17262466 N1305BTriangle Aviators LLC · Cary, NCBuilt 2007 · S/N 172S10654 N1305FShlapak Jeffrey M · Peachtree City, GABuilt 1966 · S/N 17254800 N1305YGraupmann John S · Arlington, WABuilt 1961 · S/N 17249005 N13065Pacific Flight Academy LLC · Honolulu, HIBuilt 1973 · S/N 17262471 N13069Tabib Re · Winchester, CABuilt 1973 · S/N 17262472 N1306CWateractive43 LLC · Auburn, CABuilt 2007 · S/N 172S10655 N1306MFreedom Aviation Inc · Lynchburg, VABuilt 2006 · S/N 172S10336 N1306YOklahoma Flight Academy LLC · Owasso, OKBuilt 1961 · S/N 17249006 N13076Smith Jimmy R · Bowling Green, KYBuilt 1973 · S/N 17262477 N13077Raborn Albert F · Collinsville, VABuilt 1973 · S/N 17262478 N13078Nichols Patrick C · Fairview, NCBuilt 1973 · S/N 17262479 N13079Great Lakes Air Inc · Alpena, MIBuilt 1973 · S/N 17262480 N1307CHouse Of Raeford Farms Inc · Rose Hill, NCBuilt 2006 · S/N 172S10337 N1307GPray Aviation Inc · Augusta, KSBuilt 1966 · S/N 17254120 N1307YOrange County Flight Center Inc · Santa Ana, CABuilt 1961 · S/N 17249007 N13081Eagle East Aviation Inc · North Andover, MABuilt 1973 · S/N 17262481 N13083Cloud Surfer N13083 LLC · Helena, MTBuilt 1973 · S/N 17262483 N1308YBrewer Lester A · Magna, UTFirst renewal noticeS/N 17249008 N13093Multiflight II Inc · Lakeville, MNBuilt 1973 · S/N 17262488 N13095Air Ally Asset Management LLC · Chisago City, MNBuilt 1973 · S/N 17262489 N13096Flights Cool LLC · La Conner, WABuilt 1973 · S/N 17262490 N13099Steeber Pauline M · Mcmurray, PABuilt 1973 · S/N 17262493 N1309GPhoenix East Aviation LLC · Daytona Beach, FLBuilt 2006 · S/N 172S10342 N1309U129w Holdings LLC · Terlingua, TXBuilt 1976 · S/N 17266999 N1309YC747 LLC · Wilmington, DEBuilt 1961 · S/N 17249009 N130DABornheber Ralf · DraskovicS/N 17265713 N130JAHagele Aviation LLC · Hillsboro, ORBuilt 2002 · S/N 172S9165

Back to AD 90-06-03 R1