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.

N89372Rodriguez Devin · Arlington, TXBuilt 1978 · S/N 15282729 N89377Bishops' Ltd · Virginia Beach, VABuilt 1978 · S/N 15282732 N8938SBallou Skies Aviation Inc · Bucyrus, OHBuilt 1965 · S/N 15062238 N8938UJofredo Corp · Zephyrhills, FLBuilt 1976 · S/N 15078024 N89390Nevill Jordan J · Ukiah, CABuilt 1978 · S/N 15282734 N89430Flabob Airport LLC · Jurupa Valley, CAS/N 15282741 N89433Chapel Hill Flying Club Inc · Sanford, NCBuilt 1978 · S/N 15282743 N89438Sun Aircraft Management LLC · Ormond Beach, FLBuilt 1978 · S/N 15282747 N89456Czyzewski Justin · East Brunswick, NJBuilt 1978 · S/N 15282755 N89469Hershberger David A · Unionville, INBuilt 1978 · S/N 15282759 N8947SMatyas Aviation Inc · Sugarloaf, PABuilt 1965 · S/N 15062247 N89531Glynco Manning Aviation Inc · Brunswick, GABuilt 1978 · S/N 15282771 N89533Ashby Shawn Alan · San Luis Obispo, CABuilt 1978 · S/N 15282773 N89539Jkg LLC · Murfreesboro, TNBuilt 1978 · S/N 15282775 N89549Jodkin Jason J · Confluence, PAFirst renewal noticeBuilt 1978 · S/N 15282781 N8954URausch John H · Fairport, NYBuilt 1976 · S/N 15078026 N8955SHewett Donnie · Little River, SCS/N 15062255 N8957SMiller Andy · Marana, AZBuilt 1965 · S/N 15062257 N89585Vinland Flight School LLC · Topeka, KSBuilt 1978 · S/N 15282796 N89588Jet & Rotor Aviation LLC · Sacramento, CABuilt 1978 · S/N 15282797 N8958SLeo Richard E · Malibu, CABuilt 1965 · S/N 15062258 N89600Philbrick Rodney C DBA · Bishop, CABuilt 1978 · S/N 15282801 N8961SJoham James R · Kurten, TXBuilt 1965 · S/N 15062261 N8961UKqadvantage LLC · Orlando, FLS/N 15078031 N8963UAvia Aero Services Inc · Flagler Beach, FLBuilt 1976 · S/N 15078033 N896482fly-Safety LLC Trustee · Azle, TXBuilt 1977 · S/N 15282816 N89652Lexington Flying Club Inc · Lexington, KYBuilt 1978 · S/N 15282819 N89653Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1978 · S/N 15282820 N8965SKaufman Jayson R · Moundridge, KSBuilt 1965 · S/N 15062265 N89661Kelly William W · Springfield, ORBuilt 1978 · S/N 15282821 N89664Mulligan James Michael Trustee · Mesa, AZBuilt 1978 · S/N 15282822 N8967SDemontgomery Peter J · Fyffe, ALBuilt 1965 · S/N 15062267 N89681Wings Over Texas Holdings LLC · Denton, TXBuilt 1978 · S/N 15282824 N8968NMowery Robert · Irvine, CABuilt 1970 · S/N A1500163 N89693Rjw Aviation LLC · Tampa, FLBuilt 1978 · S/N 15282827 N89702Carter Flygare Inc · Sacramento, CABuilt 1978 · S/N 15282830 N8970SMiller Curtis D · Malabar, FLBuilt 1965 · S/N 15062270 N89718Schad Paul E · Gainesville, TXBuilt 1978 · S/N 15282839 N89727Wings Over Texas Holdings LLC · Denton, TXS/N 15282844 N89735N89735 LLC · Stuart, FLBuilt 1978 · S/N 15282847 N89743Heavy Metal Air LLC · Farmingdale, NYBuilt 1978 · S/N 15282850 N8974SRegistration Pending · Bentonville, ARRegistration pendingS/N 15062274 N89753Aerohead Planes LLC · Savannah, GAS/N 15282853 N89764South Aero LLC · Albuquerque, NMS/N 15282857 N8976SHattaway Laura C · Rossville, GABuilt 1965 · S/N 15062276 N89770Seals Richard W · Torrance, CAS/N 15282860 N89780Huffman Jacob M III · Burleson, TXBuilt 1978 · S/N 15282865 N8979SFurtadobradley D · Lodi, CAS/N 15062279 N89800Ballesteros Irlena · Glendale, CAS/N 15282872 N89812Fremont Aviation Inc · Fremont, NEBuilt 1978 · S/N 15282879

Back to AD 2009-10-09 R2