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.

N4724XFlying My Dreams LLC · Miami Gardens, FLS/N 15064774 N47253De Wan Madisun Nicole · Tarpon Springs, FLBuilt 1979 · S/N 15283198 N47261Future American Aviators LLC · Davie, FLS/N 15283204 N47268Jones Benn D · Bell, FLBuilt 1979 · S/N 15283206 N4726BMurray Kenneth · Parkville, MDBuilt 1979 · S/N 15283600 N4726XDoebler H Andrew · Myrtle Beach, SCBuilt 1966 · S/N 15064776 N4727HJet & Rotor Aviation LLC · Sacramento, CABuilt 1979 · S/N 15283971 N4727XN4727x LLC · Palmdale, CAS/N 15064777 N4730BPotter Jay O · Charlotte, NCBuilt 1979 · S/N 15283602 N4730XDawson Allen J · Wshngtn Ct Hs, OHS/N 15064780 N4734ANewman Macy M · Plano, TXBuilt 1979 · S/N A1520885 N4734XMclennon Daniel C · Boynton Beach, FLBuilt 1966 · S/N 15064784 N47354Wings Over Texas Holdings LLC · Denton, TXBuilt 1979 · S/N 15283220 N4737LSouthwinds Export Inc · Kissimmee, FLNon-citizen corporation, flight hours not reportedS/N 15284228 N4738XHageness Todd A · Rugby, NDS/N 15064788 N4739XKimberly Jack L · Shippensburg, PABuilt 1966 · S/N 15064789 N47417Kirst Forest Mitchell · Fairbanks, AKBuilt 1979 · S/N 15283224 N47422Sfdb Aviation Inc · Pompano Beach, FLBuilt 1979 · S/N 15283225 N4742XMurphy Chong Yi · Fernandina Beach, FLBuilt 1966 · S/N 15064792 N4745PNorris Phillip A · Stanton, CABuilt 1980 · S/N 15284808 N4749XFlaat Stephen C · Bemidji, MNBuilt 1966 · S/N 15064799 N4750XSc Aircraft LLC · Copper Canyon, TXS/N 15064800 N4752BCelestial Associates LLC · Jonesboro, GAS/N 15283616 N4753XUpstate Flying Club Inc · Marcy, NYBuilt 1966 · S/N 15064803 N4755PJet & Rotor Aviation LLC · Sacramento, CABuilt 1980 · S/N 15284810 N47563Mike Mooney Construction LLC · Wilmington, DEBuilt 1979 · S/N 15283235 N47567Jordan Clifford A · Woodbridge, VABuilt 1979 · S/N 15283236 N4757XFountain John D Jr · Lynchburg, SCBuilt 1966 · S/N 15064807 N47582Beckham Jackie D Trustee · Coyle, OKS/N 15283238 N47586Pea-Wayman Flight LLC · Daytona Beach, FLS/N 15283239 N47587Neel Aviation LLC · Lakeland, FLS/N 15283240 N4759XBaginsky D D · Salesville, OHBuilt 1966 · S/N 15064809 N4761LWings Over Texas Holdings LLC · Denton, TXBuilt 1980 · S/N 15284229 N4762XSpatiumtech LLC · Madison, ALBuilt 1966 · S/N 15064812 N4766B4 One Air LLC · Holland, MIBuilt 1979 · S/N 15283624 N47672Cruiseair Aviation Inc · Ramona, CABuilt 1979 · S/N 15283243 N4769QFlight Time LLC · El Paso, TXBuilt 1981 · S/N 15285062 N4769XAnderson Aviation LLC · Erie, PABuilt 1966 · S/N 15064819 N476MSBrooks Duane T Trustee · Mount Shasta, CAS/N 15077515 N476TCFlorida Flight Training Center Inc · Venice, FLBuilt 1979 · S/N 15283281 N4773LSilver Express Co DBA · Miami, FLBuilt 1980 · S/N 15284230 N4773XBlack Diamond Aviation LLC · Rathdrum, IDBuilt 1967 · S/N 15064823 N4774PCannan Aviation Inc · Georgetown, TXBuilt 1980 · S/N 15284813 N4776XMersiowsky Richard R · King George, VABuilt 1966 · S/N 15064826 N4777HMorey Airplane Co Inc · Middleton, WIBuilt 1979 · S/N 15283978 N47791Schwartz John E · Ventura, CABuilt 1979 · S/N 15283250 N4779XSnodgrass James T · Gallipolis, OHBuilt 1966 · S/N 15064829 N47808Colgan Aviation LLC · La Crosse, WIBuilt 1979 · S/N 15283253 N4780XBroyles Dean L · Pittsboro, INBuilt 1966 · S/N 15064830 N4781XMartinez Ivan A · Oro Valley, AZBuilt 1966 · S/N 15064831

Back to AD 2009-10-09 R2