Registered aircraft · 177

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:2003-22-07-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:2003-22-07-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:2003-22-07-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:2003-22-07-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:2003-22-07-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:2003-22-07-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.

N324GMSycan Corp DBA · Paso Robles, CABuilt 1974 · S/N 310 N325MASouthern Aviation LLC · Durham, NCBuilt 1974 · S/N 325 N32ECAlan H Brodine Dmd Pc · Rochester, NYBuilt 1977 · S/N 699SA N333ZPWashington Road Properties Level 2 LLC · Highlands, NCS/N 363SA N338MLJdm Aviation LLC · Marceline, MOBuilt 1981 · S/N 1539SA N33EWAircraft Trustee Services Inc Trustee · Dover, DEBuilt 1981 · S/N 1519 S.A.N350RGAdams Michael D · Mckinney, TXBuilt 1980 · S/N 773 S.A.N352WMMu-2 American Services Inc · Dover, DEBuilt 1978 · S/N 385SA N356AJRealstaff Rocket LLC · Keizer, ORBuilt 1978 · S/N 381SA N360RAMillennium Flight Leasing Inc · Wilmington, DES/N 740SA N361MAReturnlogic Inc · Apollo Beach, FLBuilt 1980 · S/N 429 S.A.N36ATPlanesusa.Com LLC · Dover, DEBuilt 1980 · S/N 426 S.A.N370MAAir 1st Aviation Companies Inc · Aiken, SCS/N 370SA N375ACCelco Constantine Eng Lab Co · Wilmington, DEBuilt 1975 · S/N 327 N383TXPositive Rate LLC · Eatonton, GABuilt 1975 · S/N 332 N3GTR&G Aircraft LLC · Zeeland, MIS/N 277 N3MAAir 1st Aviation Compainies Inc · Aiken, SCS/N 1511 S.A.N400PSBarnett Sheila · Catoosa, OKBuilt 1979 · S/N 411 S.A.N40AMAisling Developments LLC DBA · Calhoun, GABuilt 1980 · S/N 427 S.A.N40JJIntercontinental Jet Service Corp · Tulsa, OKBuilt 1978 · S/N 383SA N40KCAir 1st Aviation Companies Inc · Glendale, AZBuilt 1974 · S/N 322 N423DB2945l LLC · Terrell, TXS/N 1543 S.A.N42AFWild Hare Enterprises LLC · Valparaiso, INBuilt 1980 · S/N 787 S.A.N444WFZadeh Aviation Group LLC · El Centro, CAS/N 1551 S.A.N449BKMu2b40 LLC · Rancho Santa Fe, CABuilt 1981 · S/N 449 S.A.N44AFTrinity Group · Watford City, NDBuilt 1981 · S/N 790SA N44MXRiver City Aviation Inc · Fairdealing, MOBuilt 1981 · S/N 1526 S.A.N44VRKrause Daniel Trustee · Blue Island, ILS/N 432 S.A.N450FSRaju Leasing Co LLC · Jackson, MSBuilt 1976 · S/N 338 N459SASolitaire Leasing LLC · Evanston, ILS/N 459 S.A.N461MAGood Aviation LLC · Oshkosh, WIBuilt 1974 · S/N 301 N462MARegistered aircraftBuilt 1974 · S/N 302 N466DCAerotel Inc · Spring Hill, FLBuilt 1981 · S/N 1528SA N467MAAlc Aviation LLC · Cheyenne, WYS/N 1567SA N46AKExpress Aviation Management LLC · Dover, DEBuilt 1979 · S/N 754S.A.N477DDGillen Diesel Aviation LLC · Dania Beach, FLBuilt 1981 · S/N 439SA N480AFAir 1st Aviation Companies Inc · Aiken, SCS/N 248 N481AFAir 1st Aviation Companies Inc · Tyndall Afb, FLS/N 253 N482AFAir 1st Aviation Companies Inc · Tyndall Afb, FLS/N 265 N483AFAir 1st Aviation Companies Inc · Aiken, SCBuilt 1973 · S/N 271 N485AFLaver Michael · Glendale, AZBuilt 1974 · S/N 308 N486AFAir 1st Inc · Tyndall Afb, FLBuilt 1975 · S/N 329 N487AFAir 1st Aviation Companies Inc · Tyndall Afb, FLBuilt 1975 · S/N 333 N489AFLaver Michael · Glendale, AZS/N 243 N48NPJere Aviation LLC · Fond Du Lac, WIBuilt 1981 · S/N 447 S.A.N4RRough Ryder Aircraft Inc · Carmel, NYBuilt 1981 · S/N 1542 S.A.N4WDHat Creek Aviation LLC · Hamilton, MTBuilt 1979 · S/N 399 S.A.N500LEPlsr LLC · Denton, TXBuilt 1977 · S/N 351SA N500PJFly2mellc · Ooltewah, TNBuilt 1974 · S/N 668 N507ZZAce Aviation LLC · Mankato, MNS/N 264

Back to AD 2003-22-07 R1