OpenAirDocs.org
AD 99-05-13 R1 WD

Registered aircraft · 13,518

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

N6690GKey Lime Real Estate Inc · Lutz, FLBuilt 1979 · S/N E-1625N6690YThree Green LLC · Towanda, KSBuilt 1979 · S/N E-1627N66912Mcintyre Daniel J · Bristol, CTS/N MC794N66913Mp Air LLC · Stonewall, LABuilt 1979 · S/N E-1631N66916Technet Aviation LLC · Charlotte, MIS/N D-10327N66919Gta Air Inc · Addison, TXBuilt 1979 · S/N E-1634N66928International Air Services Inc Trustee · Carson City, NVBuilt 1979 · S/N E-1628N6692RToga LLC · Scottsdale, AZBuilt 1980 · S/N EA-55N66932Worstell Kris D · Gordonville, TXBuilt 1979 · S/N E-1630N6695DExtrusions Inc · Fort Scott, KSBuilt 1980 · S/N E-1657N6695HMegan Anderson Nursing Services Inc · Yucaipa, CABuilt 1980 · S/N D-10343N6695NJosselyn David A · Riverside, CABuilt 1979 · S/N CE-895N6696DMayfly Aviation LLC · Quincy, FLBuilt 1980 · S/N E-1636N6696WClift William R II · Princeton, KYBuilt 1980 · S/N D-10329N6696YAlcri Inc · Lewes, DES/N E-1639N6696ZMonahans Affordable Homes LLC · Monahans, TXBuilt 1980 · S/N EA-56N6697DAtlanta Aviation Academy Inc · Lawrenceville, GABuilt 1979 · S/N ME-264N6697ZFlying Realtor LLC · Jamaica, NYBuilt 1979 · S/N MC-695N6698EGr3en Inc · Honolulu, HIS/N MC-697N6698FHarding Michael D · Orlando, FLBuilt 1979 · S/N MC-698N6698HNational Test Pilot School · Mojave, CABuilt 1979 · S/N ME-273N6698QBrager Robert L · Oxnard, CABuilt 1983 · S/N M-2391N6699SBeach Coleen W · Moncks Corner, SCS/N M-2225N669D1000 Springs Aviation LLC · Buhl, IDBuilt 1951 · S/N D-2940N669KMAviation Consultants Inc · Wilmington, DES/N CJ139N669PFBurkitt Harry G · Lebanon, TNBuilt 1980 · S/N TC-2297N669RPFanning William J · Dallas, TXBuilt 1979 · S/N E-1618N66ABCallis Jerrod G · California, KYBuilt 1969 · S/N CE-292N66CAM L Air Inc · Tulsa, OKBuilt 1974 · S/N TC-1703N66FCIshawooa Air LLC · Cody, WYBuilt 1955 · S/N G-741N66GMEdge Logistics Inc · Southlake, TXBuilt 1969 · S/N LB-1N66HBSawtooth Travel Solutions LLC · Twin Falls, IDBuilt 1976 · S/N E-888N66HPTwin Lakes LLC · Englewood, COBuilt 1980 · S/N P-530N66HWStender Aviation D LLC · Huntsville, ALBuilt 1980 · S/N P-559N66JCCarney James D · Germantown, TNBuilt 1977 · S/N TC-2063N66JLLucia Joanne · Agawam, MABuilt 1975 · S/N E-711N66KDEnalp Investments LLC · Metairie, LABuilt 2003 · S/N E-3505N66KWPeavy Michael J Trustee · Chico, CAS/N CE-948N66LAAviary LLC · Greer, SCBuilt 1987 · S/N E-2394N66LCBusiness Jet Consultants LLC · Derby, KSBuilt 1977 · S/N E-1050N66LHLane Law Firm Pc · Greenwood Village, COBuilt 1981 · S/N EA-261N66NPOtero Naomi Rodriguez · Kissimmee, FLBuilt 1971 · S/N TC-1407N66PDHaines Christopher B · Fort Worth, TXBuilt 1949 · S/N D-1938N66PLValiair Lc Trustee · Casper, WYBuilt 1980 · S/N P-532N66QMSammons Shaun W · Memphis, TNBuilt 1957 · S/N DH-161N66SRInbound LLC · Overland Park, KSBuilt 1968 · S/N TC-1093N66SSAyers Leland Clayton II · Carlsbad, CABuilt 1973 · S/N TC-1567N66TCJohnson Dennis A · Bowman, GAS/N D-8061N66TPAmerican Aviation Aircraft Leasing Inc · El Cajon, CABuilt 1979 · S/N ME-164N66VBButschky Jeffrey · Baldwin, MDBuilt 1978 · S/N CE-830
Back to AD 99-05-13 R1 WD