Skip to content

Registered aircraft · 82

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

N10JFRempert Erich A · Lake Geneva, WIS/N NAV-4-1391 N10WDEgmond Aircraft LLC · Lewes, DEBuilt 1964 · S/N NAV-4-2494 N114ERempert Erich A · Lake Geneva, WIS/N NAV-4-16 N120LDJ & G Aircraft LLC · Chandler, AZBuilt 1961 · S/N NAV-4-2355 N1622TMcpherson Bruce A · Burien, WABuilt 1962 · S/N NAV-4-2468 N1EWNelson Patrick A · Winston, GABuilt 1962 · S/N NAV-4-2480 N21ZZMadshack Aviation LLC · Reston, VABuilt 1962 · S/N NAV-4-2405 N2357TB & R Aviation LLC · Pine Knoll Shores, NCBuilt 1961 · S/N NAV-4-2357 N2358TNewcom Bradly C · Hanson, KYBuilt 1961 · S/N NAV-4-2358 N2360TAerojet Sevices Inc · Aurora, COBuilt 1961 · S/N NAV-4-2360 N2363TKan-Do Inc · Danbury, CTBuilt 1961 · S/N NAV-4-2363 N2365TTodd John R · Flower Mound, TXBuilt 1962 · S/N NAV-4-2365 N2367THunsaker Matthew L · De Pere, WIBuilt 1961 · S/N NAV-4-2367 N2369TRangemaster Adventures LLC · Union Hall, VABuilt 1965 · S/N 2369 N2370TR Douthitt Enterprises Inc · El Centro, CAS/N NAV-4-2370 N2401TRempert Randel L · Antioch, ILBuilt 1962 · S/N NAV-4-2401 N2402TMoehling Richard Lee · Cleveland, OKBuilt 1962 · S/N NAV-4-2402 N2406TThibault William K · Colonial Heights, VAS/N NAV-4-2406 N2408TR E Green Inc · Three Forks, MTBuilt 1962 · S/N NAV-4-2408 N2409TGarabedian John H · Southborough, MABuilt 1962 · S/N NAV-4-2409 N2413RMachamer John K · Gettysburg, PABuilt 1962 · S/N NAV-4-2413 N2415TWeaver George T · Fairbanks, AKBuilt 1962 · S/N NAV-4-2415 N2416TFebruary Aviation LLC · Lake Geneva, WIBuilt 1962 · S/N NAV-4-2416 N2420TMj Distributors · Woodland, CABuilt 1962 · S/N NAV-4-2420 N2422TImhof Anton B · Littlefork, MNBuilt 1962 · S/N NAV-4-2422 N2423TCampana Maximo Alfredo · Kyle, TXBuilt 1962 · S/N NAV-4-2423 N2424TWhiskey Fox Inc · Kearney, NEBuilt 1962 · S/N NAV-4-2424 N2425TIowa Valley Aviation Inc · Oxford, IABuilt 1964 · S/N NAV-4-2425 N2426TDowden Frank D · Fallbrook, CABuilt 1962 · S/N NAV-4-2426 N2427TNilson Henry A Trustee · Holtville, CABuilt 1962 · S/N NAV-4-2427 N2428TDavis John J · Anderson, SCBuilt 1962 · S/N NAV-4-2428 N2430TTurner Douglas N · Sacramento, CABuilt 1962 · S/N NAV-4-2430 N2431THerrington Ronald Bruce · Ray City, GABuilt 1962 · S/N NAV-4-2431 N2433TNw Aircraft Sales & Lesing LLC · Scappoose, ORS/N NAV-4-2433 N2436TFriesen Gregory J · Evansville, WYBuilt 1962 · S/N NAV-4-2436 N2437TWilson Matthew · Adrian, MIS/N NAV-4-2437 N2438TSupp Robert W · Wells, NVBuilt 1962 · S/N NAV-4-2438 N2441TSelzer William J · Newaygo, MIBuilt 1962 · S/N NAV-4-2441 N2442TBrooks Samuel A · Germantown, TNS/N NAV-4-2442 N2443TN2443t LLC · High Springs, FLBuilt 1962 · S/N NAV-4-2443 N2446TRawls Thomas R · Cincinnati, OHBuilt 1962 · S/N NAV-4-2446 N2447TMontcalm Aviation LLC · Coral, MIBuilt 1962 · S/N NAV-4-2447 N2448TByrd Jonathan L · Rome, GABuilt 1962 · S/N NAV-4-2448 N2450TSivilich George M · Burlington, NJBuilt 1962 · S/N NAV-4-2450 N2453TMulhall Timothy P · Lampasas, TXBuilt 1962 · S/N NAV-4-2453 N2456TMercer County Rehab Supply Inc · Grove City, PABuilt 1962 · S/N NAV-4-2456 N2457TKnesek John H · College Station, TXBuilt 1962 · S/N NAV42452 N2458TKimble Jonathan L · Spring Valley, CABuilt 1962 · S/N NAV-4-2458 N2459TDaglewicz Richard · Cincinnati, OHBuilt 1962 · S/N NAV-4-2459 N2460THale Robert D · Waveland, INBuilt 1962 · S/N NAV-4-2460

Back to AD 64-04-05