Skip to content

Registered aircraft · 1,458

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:96-24-17-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:96-24-17-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:96-24-17-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:96-24-17-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:96-24-17-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:96-24-17-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.

N1688KHenley Charles D · New London, NCBuilt 1946 · S/N 4415 N1689KChladek Gabriel J · Sisters, ORS/N 4416 N1690KSchreiber Curtis P · Worden, ILS/N 4417 N1693KOlson Russell O · Eureka Springs, ARS/N 4420 N1694KKorman Nicholas · Lebanon, INBuilt 1947 · S/N 4421 N16CYSanchez Joseph I · Jonesville, KYBuilt 1946 · S/N 3204 N1707KWard Lional Ray · Varnville, SCBuilt 1947 · S/N 4434 N1712KDethardt James J · Little Chute, WIBuilt 1947 · S/N 4439 N1713KRegistration Pending · Columbia, MORegistration pendingS/N 4440 N1715KHurlburt Ronald V DBA · Durand, WIBuilt 1946 · S/N 4442 N1717KJ Smith Ranch Inc · Condon, ORBuilt 1949 · S/N 4444 N1721KLetkeman John K · Seminole, TXS/N 4448 N1722KKechner Scott · New Hudson, MIBuilt 1946 · S/N 4449 N1733KSogge Bjorn R · Spicer, MNBuilt 1946 · S/N 4460 N1739KBas Part Sales LLC · Greeley, COBuilt 1946 · S/N 4466 N1741KSimply Living LLC · Fort Myers, FLS/N 4468 N1761KGrant Cynthia S · Austin, TXBuilt 1946 · S/N 4488 N1764KMurray Gregory T · Napa, CAS/N 4491 N1765KNesmith Matthew D · Marietta, GABuilt 1946 · S/N 4492 N1767KRegistration Pending · Clancy, MTRegistration pending, pending cancellationS/N 4494 N1770KFlip Turn LLC · Washington, DCBuilt 1946 · S/N 4497 N1773KJasinski Jack J · Necedah, WIBuilt 1946 · S/N 4500 N1776KRodney William Debaun Family Lp · Midlothian, TXS/N 4503 N1778BBrosette Victor N · Dallas, TXBuilt 1948 · S/N 6401 N1784KTony Flies Inc · Sparta, NCS/N 4511 N1786KClemens Ryan · Wasilla, AKBuilt 1946 · S/N 4513 N1793KRegistration Pending · Jupiter, FLRegistration pendingBuilt 1946 · S/N 4520 N1795KNeeser Ryan R · Anchorage, AKBuilt 1946 · S/N 4522 N17UBHannemann James R · Mercer, WIBuilt 1948 · S/N 5947 N1802BRegistered aircraftBuilt 1948 · S/N 6229 N1802KTrofimoff Alexander V · Overland Park, KSS/N 4529 N1803BBorchers Jonathan M · Independence, ORBuilt 1948 · S/N 6230 N1804BLyman John W · Orrs Island, MEBuilt 1948 · S/N 6231 N1805KJohnson Lawrence F · Anchorage, AKBuilt 1947 · S/N 4532 N1806KWells Charles Richard · Hayden, IDS/N 4533 N1810BRegistration Pending · Bourbonnais, ILRegistration pendingBuilt 1948 · S/N 6237 N1811KGage Lewis Trustee · Reno, NVBuilt 1946 · S/N 4538 N1812KMichaelsen Mark R · Leesburg, VABuilt 1946 · S/N 4539 N1813KWilliams Jay P · Moses Lake, WABuilt 1946 · S/N 4540 N1815BHaugen Michael C · Oklahoma City, OKBuilt 1948 · S/N 6242 N1816KCartledge Douglas J · Seville, OHS/N 4543 N1817BSlack Jonathan D · Bonfield, ILBuilt 1948 · S/N 6244 N1818BWilliams Timothy W · West Monroe, LABuilt 1948 · S/N 6245 N1822BRidgeway Beata 1 · Valewood Rd, ILBuilt 1948 · S/N 6249 N1822KSipple Ronald W Jr · Gardner, KSBuilt 1946 · S/N 4549 N1823KCooper Stephen · Fairbanks, AKS/N 4550 N1825BKruse Adam L · Weiser, IDS/N 6252 N1825KSigler L Lanning · Albuquerque, NMBuilt 1946 · S/N 4552 N1827BWakefield John DBA Skyways · Cooperstown, NDBuilt 1948 · S/N 6254 N1829KGood Brian · Wildomar, CABuilt 1946 · S/N 4556

Back to AD 96-24-17 R1