Registered aircraft · 108,433

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:2007-04-19-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:2007-04-19-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:2007-04-19-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:2007-04-19-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:2007-04-19-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:2007-04-19-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.

N24440Stikes Aviation LLC · Griffin, GABuilt 2001 · S/N 18280956 N24447Mustang Sally Aviation LLC · Camden, SCBuilt 2006 · S/N 172S10122 N2444GDurbin Brian · Lone Tree, COBuilt 1959 · S/N 51744 N2444HChristiansen Aviation LLC · Wilmington, DEBuilt 2000 · S/N 17280874 N2444JDavis Bret R · Boynton Beach, FLBuilt 1979 · S/N 18-7909124 N2444PMcgowan Robert A · Burgaw, NCS/N 22-2815 N2444QBristow Christopher W · Fairfield, TXBuilt 1966 · S/N 18257644 N2444RClancy Michael · Rifle, COBuilt 1964 · S/N 18255544 N2444XRocha Frank N · Knights Ferry, CAFirst renewal noticeBuilt 1965 · S/N 18256344 N24450Haley David A · Whitethorn, CABuilt 2004 · S/N 001 N2445JBuzzard Aviation Inc · Freer, TXBuilt 2000 · S/N 20608095 N2445PBolivar Flyers Inc · Brighton, MOBuilt 1955 · S/N 22-2816 N2445RVan Bortel Aircraft Inc · Arlington, TXBuilt 2005 · S/N 18281720 N2445VN2445v Cessna Inc Trustee · Wilmington, DEBuilt 2000 · S/N 18280699 N2445XBald Eagle Aviation LLC · West Chester, PABuilt 1965 · S/N 18256345 N2446ASkybound Aviation LLC · Bixby, OKBuilt 2000 · S/N 18280695 N2446CGolike Timothy R · Anchorage, AKBuilt 1954 · S/N 30746 N2446GAcute Holdings LLC · Jenks, OKBuilt 1959 · S/N 51746 N2446REdgon Inc · Orlando, FLS/N 18280697 N2446SFerreby Thomas E · Stroudsburg, PABuilt 2000 · S/N 18280698 N2446TRawls Thomas R · Cincinnati, OHBuilt 1962 · S/N NAV-4-2446 N2446VLipscomb Rik · Wichita Falls, TXFirst renewal noticeBuilt 1983 · S/N 14795330 N2446XWashington State Patrol · Olympia, WABuilt 2000 · S/N 20608097 N2446ZEdb Air Inc · Wilsonville, ORBuilt 2006 · S/N 172S10118 N24470Bauer Richard E · Livermore, CABuilt 2000 · S/N 18280823 N2447ADyer Clifton R · Richland, WABuilt 2004 · S/N 70966 N2447BSilver Express Co · Miami, FLBuilt 1999 · S/N 17280801 N2447CLevya Kevin S · Wilbur, WAS/N 30747 N2447DAtp Aircraft 2 LLC · Wilmington, DEBuilt 1999 · S/N 17280803 N2447GTroyer Thomas · Chickamauga, GABuilt 1959 · S/N 51747 N2447QEaton James B · Green Bank, NJBuilt 1966 · S/N 18257647 N2447RGift Academy Inc · Vernon, TXBuilt 1969 · S/N 28-5623 N2447TMontcalm Aviation LLC · Coral, MIFirst renewal noticeBuilt 1962 · S/N NAV-4-2447 N24483Fly 172r LLC · Peoria, AZBuilt 2000 · S/N 17280982 N2448AAviation Trust Co LLC Owner Trustee · Oklahoma City, OKBuilt 2015 · S/N TH-2448 N2448BChristiansen Aviation LLC · Wilmington, DEBuilt 2000 · S/N 17280978 N2448EPwc Engine Air Inc · Manorville, NYS/N 17271288 N2448FFlynn Charles P · Anchorage, AKBuilt 1965 · S/N 18051648 N2448PHopkins Andrew J · Pickett, WIS/N 001 N2448QEuroaviation Inc Trustee · KematenS/N 18257648 N2448RRegistration Pending · Highland Lakes, NJRegistration pendingS/N 28-5624 N2448TByrd Jonathan L · Rome, GABuilt 1962 · S/N NAV-4-2448 N2448XBlough Robert M · Hoonah, AKBuilt 1965 · S/N 18256348 N2449AWestbank Fishing LLC · Kiln, MSBuilt 1999 · S/N 18280632 N2449CAirmart Aircraft Holdings Inc · Oak Ridge, NCBuilt 1999 · S/N 18280633 N2449EWikette Mathias · West Chester, OHBuilt 1970 · S/N 28-26801 N2449FBoccuti Salvatore A · Ambler, PABuilt 1966 · S/N 18051650 N2449GDimzoff Justin W · Hines, ORFirst renewal noticeBuilt 1959 · S/N 51749 N2449JSkydance Northwestern Inc · Minden, NVBuilt 1982 · S/N 18504364 N2449PSchulze Thomas A · Bloomville, OHBuilt 1955 · S/N 22-2821

Back to AD 2007-04-19 R1