Skip to content

AD 2009-10-09 R2

Registered aircraft · 8,565

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

N3563LMartinez Guillermo E · Upland, CABuilt 1965 · S/N 15062363 N3566VMbsp Enterprises Inc · Wilmington, DEBuilt 1975 · S/N 15076548 N3573LGlasgow Jason D · Tecumseh, OKBuilt 1965 · S/N 15062373 N3574LMillican Marc J · Anchorage, AKFirst renewal noticeBuilt 1965 · S/N 15062374 N3575LSwann Robert A · Hereford, AZS/N 15062375 N3575VSale Reported · Acworth, GASale reportedS/N 15076552 N3577LWimpey Robert J · Roundhill, KYBuilt 1965 · S/N 15062377 N3581FSkyline Aviation Services LLC · Miramar, FLBuilt 1973 · S/N A1500413 N3584LKlesser Zachary S · Coronado, CABuilt 1965 · S/N 15062384 N3584VMurdoch Bryan · Lantana, FLBuilt 1975 · S/N 15076553 N3588LVandegrift David H · St Paul, MNBuilt 1965 · S/N 15062388 N3589LSale Reported · Bloomburg, TXSale reportedBuilt 1965 · S/N 15062389 N358KSForgues Inc · Wilmington, DEBuilt 1967 · S/N 15066671 N3597VMcleod Patrick J · Overgaard, AZBuilt 1975 · S/N 15076557 N3598LBryan Aviation LLC · Peoria, AZBuilt 1965 · S/N 15062398 N3599VMakee Markus · Painesville, OHBuilt 1975 · S/N 15076558 N35RJEarles Kenneth D · Crowley, LABuilt 1966 · S/N 15062932 N3604JSmtm Holdings Inc · Wilmington, DES/N 15064904 N3605JBon Investment Holdings LLC · Zephyrhills, FLBuilt 1966 · S/N 15064905 N3606JElite Fleet Jacksonville LLC · Jacksonville, FLBuilt 1966 · S/N 15064906 N3607JSmith Zachary L · Piedmont, SCBuilt 1966 · S/N 15064907 N3607VDel Vecchio Thomas L · Middlebury, INBuilt 1975 · S/N 15076560 N3608JSwartzentruber Thomas L · Oakland, MDBuilt 1966 · S/N 15064908 N3611JShannon James P · Vandergrift, PABuilt 1966 · S/N 15064911 N3613JBatista Brasil Vagner · Orlando, FLBuilt 1966 · S/N 15064913 N3614JSikveland Beau D · Circle, MTBuilt 1966 · S/N 15064914 N3616JB&R Aircraft LLC · Wadsworth, OHBuilt 1966 · S/N 15064916 N3617JShowalter Steven L · Goshen, INBuilt 1966 · S/N 15064917 N3618JWright David G · Lake Oswego, ORBuilt 1966 · S/N 15064918 N3620JBerens Eric A · Stevens Point, WIBuilt 1966 · S/N 15064920 N3621JLow Cost Flying LLC · Chandler, AZBuilt 1966 · S/N 15064921 N3622VFox John E · Boonville, CABuilt 1975 · S/N 15076565 N3623VClark Cecil L · Shreveport, LABuilt 1975 · S/N 15076566 N3626JEa Cvg LLC · Erlanger, KYS/N 15064926 N3626VTorres Torres Angel G · Chesapeake, VABuilt 1975 · S/N 15076567 N3628JLucarelli David L · Moncks Corner, SCBuilt 1966 · S/N 15064928 N362LKJackson Brian J · Anchorage, AKS/N 15076026 N3632JMitterling Richard H · Boothbay Harbor, MEBuilt 1966 · S/N 15064932 N3633JMicrokit Solutions LLC · Bridgeview, ILS/N 15064933 N3634JLuft Inc · North Fort Myers, FLBuilt 1966 · S/N 15064934 N3635VTz Airways 1 LLC · Avon Park, FLBuilt 1975 · S/N 15076570 N3638JEngelskirger Karl D · Valley City, OHBuilt 1966 · S/N 15064938 N3638VHope Virginia L · Georgetown, OHS/N 15076571 N3639JPrima County Community College · Tucson, AZBuilt 1966 · S/N 15064939 N3640JCovington Brian · Florence, ALBuilt 1966 · S/N 15064940 N3641VWright John C · Windham, MEBuilt 1975 · S/N 15076573 N3644JBoggs Dilan · Nicholls, GABuilt 1966 · S/N 15064944 N3646JRegistration Pending · Cornelius, NCRegistration pending, pending cancellationBuilt 1966 · S/N 15064946 N3650JPostle Jessica Grace · Newark, OHBuilt 1966 · S/N 15064950 N3652JJet Boy LLC · Carlsbad, CABuilt 1966 · S/N 15064952

Back to AD 2009-10-09 R2