Registered aircraft · 7,097

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:2001-10-09') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2001-10-09') 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:2001-10-09')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2001-10-09')
  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:2001-10-09')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2001-10-09')
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 N100FMRivkin Gerald · Saint Augustine, FLBuilt 1969 · S/N TE-729 N100HSAir Works Ltd · Wilmington, DES/N E-3506 N100JPAviation Consulting LLC · Ada, MIS/N TH-1683 N100KSIndependent Aviation Consultants LLC · Sparks, GABuilt 2001 · S/N 29-0262 N100MLMl Aviation LLC · Boulder, COBuilt 1972 · S/N TH-249 N100NKLand Air Sea Inc · Chesapeake, VABuilt 1969 · S/N TE-767 N100PZAeromotors LLC · St James, MOBuilt 1974 · S/N TH-554 N100XHBiggs Aircraft Inc · Wellston, OKBuilt 1999 · S/N E-3249 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 N1014WAnderson Timothy R · Wilmette, ILBuilt 1973 · S/N TE-906 N1015WStanton Thomas Michael · Mcallen, TXBuilt 1973 · S/N TE-907 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 N101BMTurk Mike · Pinehurst, TXBuilt 1971 · S/N TE-847 N101CGGrant Aviation Inc · Anchorage, AKBuilt 2015 · S/N 208B5191 N101DXPatierno David M · Templeton, CABuilt 2000 · S/N 29-0221 N101FMN101fm Inc Trustee · Wilmington, DES/N 3433153 N101KGQualitair LLC Trustee · MichelstadtBuilt 1983 · S/N EA392 N101KMHolliday Dean M Trustee · Klamath Falls, ORBuilt 1985 · S/N E-2253 N101MLWesolowski Trevor · Berkeley, CABuilt 1981 · S/N 34-8233066 N101RSWillfish LLC · Vero Beach, FLBuilt 2016 · S/N 208B5289 N101TNHillsborough County Sheriffs Office · Tampa, FLS/N 20800587 N101XWJoby Aero Inc · Santa Cruz, CABuilt 1993 · S/N 208B0382 N1020AIrving Donald J · Deland, FLBuilt 2003 · S/N 29-0316 N1021URegistered aircraftBuilt 2004 · S/N 29-0325 N1021WGreystone Enterprises Inc · Oklahoma City, OKBuilt 1973 · S/N E-401 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 N1026VPa1 208b-0319 LLC · Fort Lauderdale, FLBuilt 1992 · S/N 208B0319

Back to AD 2001-10-09