Skip to content

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

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

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.

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

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.

N66VVFarrell William J · Fort Myers, FLBuilt 1966 · S/N D-8271 N66WCWeiner Ronald I · Jackson, TNBuilt 1978 · S/N D-10199 N66WZBowing Vending Co Inc · Louisville, TNBuilt 1980 · S/N TJ-321 N66XBSai Flight Services Inc · Greer, SCS/N TC-773 N67000Registration Pending · Johns Island, SCRegistration pendingS/N ME-283 N6700CKelly Aviation & Investigation LLC · Vail, AZBuilt 1980 · S/N ME-275 N67013Del Ag Aero LLC · Milton, DEBuilt 1979 · S/N M-2229 N6701RAirplane And Drone Flight Instruction LLC · Orlando, FLBuilt 1980 · S/N ME-281 N6701TAtlanta Aviation Academy Inc · Lawrenceville, GABuilt 1980 · S/N ME-285 N6701VHub City Aviation Academy LLC · Lubbock, TXBuilt 1979 · S/N ME-297 N6702DMcwilliams Christopher S · Atlanta, GABuilt 1979 · S/N M-2231 N6702XFlight Time Builders Inc · Memphis, TNBuilt 1981 · S/N ME-287 N6703PShook Andrew Parker · Mountain Brk, ALBuilt 1979 · S/N MC-703 N6704DScaled Composites LLC · Mojave, CABuilt 1980 · S/N ME-325 N6704JRussell John T · Southaven, MSBuilt 1979 · S/N M-2238 N6704LSoflo Aviation LLC · Oakland Park, FLBuilt 1979 · S/N M-2240 N67056Bonner William B · Fort Worth, TXBuilt 1980 · S/N MC-731 N6706DQualitair LLC Trustee · MichelstadtBuilt 1979 · S/N MC-705 N6706YSorbi Aviation Inc · El Cajon, CABuilt 1979 · S/N ME-299 N6707MLouis & Clark Aviation LLC · Fort Myers, FLBuilt 1979 · S/N WA-48 N6707XGromack Stephen · Bloomfield, NMBuilt 1980 · S/N M-2241 N6708NBobby Stephen M · Dunkirk, MDBuilt 1979 · S/N M-2243 N6708RStorey Timothy J · Camarillo, CABuilt 1980 · S/N M-2244 N6708SWininger Spencer C · Wichita, KSBuilt 1980 · S/N M-2245 N6708XBaumbach James P · Lodi, CABuilt 1979 · S/N WA-53 N6709FMorning Star Transportation Inc · Dardanelle, ARBuilt 1979 · S/N M-2247 N6709LBowlin Frank J · Santa Fe, NMBuilt 1979 · S/N WA-56 N6709QClear Blue Marketing Inc · Reno, NVBuilt 1983 · S/N EA-368 N670MLQualitair LLC Trustee · MichelstadtBuilt 1970 · S/N MC-65 N670TWThunderbolt Ltd · Salem, NEBuilt 1967 · S/N D-8434 N670WSchmitt Rudy · Brookshire, TXBuilt 1960 · S/N D-6445 N6710BBarnard Matthew Bryan · Fort Worth, TXBuilt 1980 · S/N M-2246 N6710DStransky Douglas J · Fredericksburg, VAFirst renewal noticeBuilt 1979 · S/N MC-709 N6711GQuality Aviation Inc · Atlanta, GABuilt 1979 · S/N ME-311 N6711RAme Flight Holdings LLC · Oasis, IDBuilt 1979 · S/N WA-60 N67123Spencer Lane Inc · Lewes, DEBuilt 1980 · S/N M-2252 N6712AMcginnis Air LLC · Rising Star, TXBuilt 1980 · S/N ME-312 N67135Aviators Next Door LLC · Newnan, GAS/N M-2257 N6713FOne Three Foxtrot LLC · Hilton Head Island, SCBuilt 1979 · S/N MC-712 N6713VMclendon Donnie E · Winder, GABuilt 1979 · S/N WA-61 N6715DHargett David · San Juan, PRBuilt 1980 · S/N M-2253 N6715HFortanas Michael J · Temecula, CABuilt 1980 · S/N M-2255 N6715SFlores Willie Torres II · Junction City, KSBuilt 1979 · S/N MC-714 N6715VByrds Wholesale Inc · Clayton, NCS/N WA-70 N6715XOleyar John A · Houston, TXBuilt 1979 · S/N M-2260 N6715YTrevitue LLC · Dripping Springs, TXS/N WA-65 N67162Nay Blaine S · Cedar City, UTBuilt 1983 · S/N MC-795 N67166Milano Matthew G · The Woodlands, TXBuilt 1980 · S/N M-2261 N67168Mgm Aero Flight Inc · Jordan, MNBuilt 1980 · S/N M-2262 N67169Arai Eisuke · San Jose, CABuilt 1979 · S/N WA-67

Back to AD 99-05-13 R1 WD