Skip to content

AD 2007-04-19 R1

Registered aircraft · 108,428

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.

N13131Premier Capital Enterprises LLC · Hurricane, UTBuilt 1958 · S/N TD-42 N1313BSwanland Robert C · San Jose, CABuilt 1958 · S/N 4072 N1313RAztexas LLC · Valley Farms, AZS/N 310J0178 N1313WSecond Kitchen LLC · Chicago, ILBuilt 1979 · S/N E-1440 N1313XM & S Airsupply DBA · Hawthorne, CAS/N 4223 N13140Trailwinds Flying Club · Savannah, MOBuilt 1973 · S/N 17262523 N13143Riffel Victor · Benton, KSBuilt 1973 · S/N 17262526 N13144Barnstormers Club LLC · Cape Coral, FLBuilt 1973 · S/N 17262527 N13147Terra Piniun LLC · Chickaloon, AKBuilt 1973 · S/N 17262529 N1314CDajczak Stanislaw P · Findlay, OHBuilt 2003 · S/N 0502 N1314DBartels Lance R · Freetown, INBuilt 1951 · S/N 19890 N1314GBas Part Sales LLC · Greeley, COBuilt 1974 · S/N 310Q1154 N1314KSimko Anthony James · Fairbanks, AKBuilt 2023 · S/N 016 N1314UKilgore Don H · Jasper, ALBuilt 1982 · S/N 21064685 N1314WNeches Air Inc · Silsbee, TXBuilt 1963 · S/N 202 N1314ZGensler Jordan T · Three Lakes, WIBuilt 1961 · S/N D-6746 N13151F N A Aviation LLC · Wakefield, MABuilt 2006 · S/N 172S10344 N13152Quirrion Linton A · Jay, MEBuilt 1973 · S/N 17262531 N13154Howell James W · Boise, IDBuilt 1973 · S/N 17262533 N13156Mph Aviation LLC · Eastanollee, GABuilt 1973 · S/N 17262535 N13157Red River Flyers Inc · Wahpeton, NDBuilt 1973 · S/N 17262536 N1315ETada Aero LLC · Worthington, OHBuilt 1978 · S/N 17270951 N1315MSpitzer John R · Rockford, ILBuilt 1975 · S/N 18264285 N1315UMcgonagill Billy D · Mount Pleasant, TXBuilt 1976 · S/N 17267004 N1315ZRiesbeck Randall C · Waynesville, OHBuilt 1961 · S/N TC-123 N13160Dey James M · Waterford, MIBuilt 1973 · S/N 17262538 N13164Jameson Kelly J · Chappell Hill, TXBuilt 1973 · S/N 17262542 N131691521 LLC · Antigo, WIBuilt 1973 · S/N 17262546 N1316JWilliams Adam Scott · Chevy Chase, MDBuilt 1975 · S/N 316 N1316NCox Kevin J · Harrison, IDBuilt 2013 · S/N 96-185/186-1077 N1316PMatthews Grover C · Hardinsburg, KYBuilt 1955 · S/N 23-356 N1316RAirgo Partners LLC · Lititz, PABuilt 1968 · S/N E-125 N1316WKurek Daniel L · Garden City, UTBuilt 1963 · S/N 204 N1316ZN1316zulu LLC · Defiance, OHBuilt 1961 · S/N D-6749 N13171Tagle Robert J · San Antonio, TXBuilt 1973 · S/N 17262548 N13178Tappan Jay M · St Helens, ORBuilt 1973 · S/N 17262549 N1317EAbove And Beyond Aviation LLC · Austin, TXBuilt 1978 · S/N 17270952 N1317MScallcess LLC · Boynton Beach, FLBuilt 1975 · S/N 18264287 N1317PWhite Christopher N · Clearwater, FLBuilt 1955 · S/N 23-357 N1317RVaughan Andy C · Sacramento, CABuilt 1977 · S/N AA5A0323 N1317SWarrior Ink · Whittier, CABuilt 1976 · S/N 18264881 N1317TWhite Tavon L · Stockbridge, GABuilt 1972 · S/N 28-7225461 N1317ULondondeery Flying Club Inc · Litchfield, NHBuilt 1976 · S/N 17267006 N1317WMorgenfeld Thomas A · Camarillo, CABuilt 1963 · S/N 205 N13180Skyward Fleet Solutions LLC · Granite Bay, CABuilt 1976 · S/N 17702402 N13182Spillman Aviation LLC · Colorado Springs, COBuilt 1973 · S/N 17262552 N13185Good Flight LLC · Colchester, CTBuilt 1973 · S/N 17262554 N13187Fly Aviation Corp · Wilmington, DES/N 17262556 N1318PDye Paul C · Mc Neal, AZBuilt 1965 · S/N 185-0871 N1318QMustang Sally Aviation LLC · Camden, SCBuilt 2008 · S/N 172S10657

Back to AD 2007-04-19 R1