OpenAirDocs.org
AD 2007-05-15

Registered aircraft · 607

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
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-05-15')
    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-05-15')
  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.

N100AJN8006j LLC · Shiloh, ILBuilt 1972 · S/N 421B0322N100JLBytelogics Inc · New York, NYS/N 421-0008N1021N1021 Inc · Wilmington, DEBuilt 1972 · S/N 12016N1027DRobins Jack S · Saint Charles, IDBuilt 1968 · S/N 421-0196N103ECAerial Surveys International LLC · Watkins, COBuilt 1967 · S/N 401-0135N10GMAlo Aviation LLC · Titusville, FLS/N T210-0151N111ECGs Wings Inc · Pawnee, ILBuilt 1967 · S/N D-8385N111PWKilgore Eric M · Genoa, NVS/N T210-0066N111SDMarc Inc · Bolton, MSBuilt 1969 · S/N 310P0200N111TFPacific Aviation Aircraft Management Inc · Ontario, ORBuilt 1974 · S/N 421B0660N111TLNdk Global Holdings Corp · Dover, DEBuilt 1974 · S/N 421B0645N112ALPassport Auto & Aviation Inc · Richmond, VABuilt 1979 · S/N 421C0697N113MPBan Air LLC · Boerne, TXBuilt 1982 · S/N 421C1235N114HVAerowerks LLC · Georgetown, TXBuilt 1973 · S/N 421B0371N116JJProgress Aviation LLC · Ellicott City, MDBuilt 1984 · S/N 421C1404N1206NCapital Group Inc · Garden City, IDBuilt 1985 · S/N 421C1805N1223HS&S Leasing Solutions LLC · Sandy Springs, GABuilt 1973 · S/N 421B0365N123BTYingling Consultation LLC · Wilmington, DEBuilt 1973 · S/N 421B0414N124TMUniversal Aviation LLC · Decatur, ARS/N 421C-0898N124WC3-B Farms Inc · Pinetown, NCBuilt 1973 · S/N 421B0484N12KNJane Air LLC · Kalamazoo, MIBuilt 1968 · S/N 421-0130N12RJDesert Air Ambulance Inc · Blythe, CABuilt 1977 · S/N 421C0306N12SNNechvatal Equipment Leasing LLC · Grand Blanc, MIBuilt 2007 · S/N 31-0019N12WTMtzb Corp · New York, NYBuilt 1974 · S/N 421B0829N1338UJstream Lc · Sheridan, WYBuilt 1965 · S/N 411-0105N13HLFreedom 421b LLC · Jacksonville, FLBuilt 1975 · S/N 421B0927N13PGJohnston Steven P · Coto De Caza, CABuilt 1976 · S/N 421C0031N1421MClausen Johan Robert · Las Vegas, NVBuilt 1976 · S/N 421C0106N1421UAviation Services Of Tn Inc · Sparta, TNBuilt 1967 · S/N 421-0046N144MLLewis University · Romeoville, ILBuilt 2000 · S/N LIV-149N144RExtrivo Inc · Lewes, DEBuilt 1967 · S/N D-8496N1463CLatta Lutz M · San Francisco, CABuilt 2003 · S/N 1356N146TJBirdboys2 Aviation LLC · Boerne, TXBuilt 1978 · S/N 421C0500N147UMartin Delano R · Spring, TXS/N D-8533N1505TN1505t LLC · Tucson, AZBuilt 1966 · S/N P206-0212N150WRWhiskey Romeo LLC · Timnath, COBuilt 1969 · S/N D-8911N1510GGmr Leasing LLC · Lincoln, DEBuilt 1974 · S/N 421B0606N151MTIsland Mountain Aviation LLC · Vesta, MNBuilt 1973 · S/N 21059861N1527GHanley Thomas W · Kissimmee, FLBuilt 1974 · S/N 421B0623N1534GRugger Investment Group LLC · Tustin, CAS/N 421B0630N1543GQds Aviation LLC · Baton Rouge, LABuilt 1974 · S/N 421B0639N1545GSaltzer Eric R · Somerton, AZBuilt 1966 · S/N T210-0208N155JQualitair LLC Trustee · MichelstadtBuilt 1972 · S/N 421B-0246N1592GCtl Legacy Holdings LLC · Midland, TXBuilt 1974 · S/N 421B0822N15ZPStefenelli Aviation N Tr Inc Trustee · AtterseeS/N 421B0919N160DCPdii LLC · Concord, NCBuilt 1980 · S/N 421C0856N1621TBeats Driving Inc · Northbrook, ILBuilt 1973 · S/N 414-0401N16ASStefenelli Aviation N Tr Inc Trustee · AtterseeBuilt 1973 · S/N 421B0317N17HLRiley Charles S · Littleton, COS/N 421B-0310N183DAHullmann John · Palo Alto, CABuilt 2003 · S/N 1349
Back to AD 2007-05-15