Skip to content

AD 2004-21-08 R1

Registered aircraft · 511

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

N1001DSpartan National Holdings LLC · Missoula, MTBuilt 1950 · S/N 7609 N1003DBarron Aviation · Perry, MOBuilt 1950 · S/N 7611 N1005DAeronautical Technical Service Inc · Collierville, TNS/N 7613 N1006DObrian Laurence J · Northridge, CAS/N 7614 N1008DRussellaire LLC · Darby, MTBuilt 1950 · S/N 7616 N1009DWelch Thomas R · Modesto, CABuilt 1950 · S/N 7617 N1010DBoggs David · Mesa, AZBuilt 1950 · S/N 7618 N1013DSweeney Sean M · Reunion, FLBuilt 1950 · S/N 7621 N1015DMickelsen Peter D · Lewistown, MTBuilt 1950 · S/N 7623 N1016DArdizzone Mark R · Mckinney, TXBuilt 1950 · S/N 7624 N1022DSmith Glenn C · University Place, WAS/N 7630 N1032DKilponen Jeffrey G · Irving, TXBuilt 1951 · S/N 7716 N1043DDarr Dennis L · Boron, CABuilt 1951 · S/N 7655 N1044DMcadam Charles T · Wichita, KSBuilt 1951 · S/N 7656 N1053DFisher Evan G · Fort Worth, TXBuilt 1951 · S/N 7665 N1054DBrown Douglas R · Centralia, WABuilt 1951 · S/N 7666 N1056DSmooth Landings LLC · Magee, MSBuilt 1951 · S/N 7668 N1057DMedore Douglas A · Romoland, CAS/N 7669 N1058DMorley Philip · Manhattan Beach, CABuilt 1951 · S/N 7670 N1068DReid James D · Thomasville, NCBuilt 1951 · S/N 7680 N1069DPrescott Scot · Alburgh, VTBuilt 1951 · S/N 7681 N1071DWestern Antique Aeroplane & Automobile Museum · Hood River, ORBuilt 1951 · S/N 7683 N1072DRegistered aircraftS/N 7684 N1074DBarron Aviation LLC · Perry, MOBuilt 1951 · S/N 7686 N1075DBrundage Donald J Jr · Green Cove Springs, FLBuilt 1951 · S/N 7687 N1077DBarron Aviation LLC · Perry, MOS/N 7689 N1080DPedron Mathew G · Chico, TXBuilt 1951 · S/N 7692 N1081DMilton William H · Amsterdam, NYBuilt 1951 · S/N 7693 N1082DSimonye Curtis F · Holmes Beach, FLBuilt 1951 · S/N 7694 N1092DManns Flying Service Inc · Lubbock, TXBuilt 1951 · S/N 7704 N1096DDaugherty Lowell E · Adelanto, CAS/N 7720 N1098DDoyle Terry · Grapevine, TXS/N 7710 N10NSpring Grove Aviation LLC · Spring Grove, ILBuilt 1951 · S/N 7657 N11RSager Timothy P · Tullahoma, TNBuilt 1952 · S/N 7765 N126JDEastland Aviation Inc · Midland, TXBuilt 1942 · S/N 7802 N126LCBeylund David L · Macon, GABuilt 1950 · S/N 7632 N126NXCombs Nicholas E · League City, TXBuilt 1951 · S/N 7858 N127DDKimberlin Mark · Grants Pass, ORS/N 7040 N127GMCorn Alley Aviation LLC · El Paso, ILBuilt 1949 · S/N 7411 N13574Warner Aric D · Rosamond, CAS/N 7108 N1401Prestonlines LLC · Wilmington, DEBuilt 1950 · S/N 7540 N145VCurrier Susan · Greenvlle Jct, MEBuilt 1948 · S/N 7135 N1500DMaxson Lee V · Mesa, AZBuilt 1951 · S/N 7722 N1502DPaolucci Christopher J · North Olmsted, OHBuilt 1951 · S/N 7724 N1505DPearce Cedric J · Chapel Hill, NCBuilt 1951 · S/N 7727 N1513DPeile Kelly T · Lakeview, ORBuilt 1951 · S/N 7735 N1514DPort Townsend Aero Museum · Port Townsend, WABuilt 1951 · S/N 7736 N1515DHolmes John A Trustee · Glen Rose, TXBuilt 1951 · S/N 7737 N1518DStegman Robert A · Saint Peters, MOBuilt 1951 · S/N 7740 N1524DSmith Richard D II · Luthersville, GABuilt 1952 · S/N 7746

Back to AD 2004-21-08 R1